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

candyman · 2013-08-28 19:03:28

Many thanks!

maverick · 2013-09-04 21:12:25

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!)

:)

candyman · 2014-08-27 18:32:14

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)

candyman · 2014-08-27 21:01:15

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?

uli · 2014-08-28 11:27:56

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)

candyman · 2014-08-28 11:47:18

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 :(

uli · 2014-08-28 12:10:07

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)

candyman · 2014-08-28 13:22:39

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)

uli · 2015-06-01 15:17:10

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)

colak · 2015-06-01 15:54:38

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

uli · 2015-06-01 16:19:03

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 …

gomedia · 2015-07-01 13:46:53

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.

Textpattern CMS

Textpattern CMS support forum

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

uli wrote #291234:

Board footer