Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#301 2013-08-28 19:03:28

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Many thanks!

Offline

#302 2013-09-04 21:12:25

maverick
Member
From: Southeastern Michigan, USA
Registered: 2005-01-14
Posts: 976
Website

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Ciges – it’s great to see people adopt orphaned plugins and update them. Thank you for sharing!

Mike

p.s. – just fwiw – The “official” way to present Textpattern is with a lower case “p”. Functionally it’s not a huge deal, but several folks around here have been working really hard on PR and branding for Textpattern, and have asked everyone to help out by taking care how we spell it. Avoid the “WordPress” creep into the logo.

I know when I first joined the community many moons ago it came out multiple ways — Textpattern, TextPattern, and my preferred Txp. (I’m still trying to break myself of that habit Destry!)

:)

Offline

#303 2014-08-27 18:32:14

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

I’ve installed Ciges’s version locally (with the latest version of XAMPP & PHP 5.5) and I get this alert (during installation):

Internal error: “preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead”.

Closing the alert window, the install get completed anyway.

Last edited by candyman (2014-08-27 18:33:51)

Offline

#304 2014-08-27 21:01:15

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

I’ve found that .sql file doesn’t work (error No. 127) and gzipped file does… :|

BTW: I’d like to restore (with this DB manager) my online site backup in localhost (XAMPP): is it possible?
Consider that the name of the DB is different… Hmm… I’ve tried to restore and I got an error… :( According to you is for the different name of the DB only?

Offline

#305 2014-08-28 11:27:56

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

candyman, are you trying to import an .sql file created with phpMyAdmin? Files created with it don’t have the “drop table if exists” command. You should use a backup file you’ve created with rss_admin_db_manager.

If you don’t have access to the online website any longer and you’re in an experimental mood, you could try and replace any instance of

CREATE TABLE `xyz_table_name` (

with

DROP TABLE IF EXISTS `xyz_table_name`;
CREATE TABLE `xyz_table_name` (

Don’t forget to use the real table names here.

Tad quicker will be to erase all the tables in your DB. (No code at hand.)

Backup before, regardless which way you decide to go!

Last edited by uli (2014-08-28 11:31:21)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#306 2014-08-28 11:47:18

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Thank you uli.

I had an online site with installed rss_admin_db_manager and I created a backupfile.sql :)

Then I’ve installed locally XAMPP with the latest version of TXP and the rss_admin_db_manager version optimized by Ciges.

At this point I’ve tried to restore my live site with the backupfile.sql but I got errot no. 127 :(

Offline

#307 2014-08-28 12:10:07

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Actually, it should be possible to import an rss_admin_db_manager backup file into phpMyAdmin. You could try that as a workaround.

Edit: Also, look whether your tables need repair, 127 might have to do with table corruption. Check also after a successful import.

Last edited by uli (2014-08-28 12:27:01)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#308 2014-08-28 13:22:39

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Yes, I managed to restore my site loading the .sql file generated by rss_admin_manager using phpMyAdmin! :)

Unfortunately some problems are arising… My previous TXP was 4.3.0 (If I remember well) and it seems incompatible with 4.5.4. I’ll start another thread, anyway…

Last edited by candyman (2014-08-28 13:46:39)

Offline

#309 2015-06-01 15:17:10

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Can anyone remember what causes backup files of only 20 bytes?

Path is /htdocs/3/355c09c4e8b3522c5b0cc112c4e608c6/web/subdirectory/files
Mysqldump-path is mysqldump, mysql-path is mysql, rights are 755 on files and its subdirectories.

What am I missing?

Edit: Also found this one mentioning complete paths for all folders, but to no avail.

Last edited by uli (2015-06-01 15:21:10)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#310 2015-06-01 15:54:38

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Hi Uli, I used to have that problem which was somehow solved by itself. I nevertheless do my backups now using the command line.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#311 2015-06-01 16:19:03

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,303

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Thanks for your reply, Yiannis. Unfortunately I need something foolproof (it’s not about the client this time ;)

After finally getting logged in for DB access (darn NetCologne admin UI!!), I’ve also tried maniqui’s tip on deleting the plugin and removing rss_dbbk entries from txp_prefs, then re-installing and yahoo-ing, but alas …


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#312 2015-07-01 13:46:53

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

uli wrote #291234:

Can anyone remember what causes backup files of only 20 bytes?

Off the top of my head, I think it indicates command not found – i.e. there’s a problem with the path to the mysql/mysqldump command.

Offline

Board footer

Powered by FluxBB