Hi pnair39

Just tried as I did push for an inbuilt option.

I didn't see an option in phpMyAdmn to directly restore/import the remote backup so I copied it by ftp to my local machine and then imported it.

The obvious issue was an import error that said

#1050 - Table 'evo_antispam' already exists

which isn't that surprising as I didn't drop all the tables before import.

So next to drop the tables and try again.

Ok that didn't work as one table didn't drop probably as I was still browsing the site and didn't put it in maintenance mode,it stopped when it found a pre-existing table. So i logged out of my site and dropped the tables again, this time they all went.

Import seemed successful but when I go to my site it says [evo.sessions] doesn't exit and sure enough in phpMyAdmin there is no such table.

So I am about to import my phpMyAdmin backup.

OK I'm bck up and running on my site Phew!!

It seems the internally backed up database was missing 5 tables 68 of 73 where imported but I haven't checked to see which, apart from the one mentioned in the error [evo.sessions]

All the best :)

Hi @pnair39,

There are no problems associated with maintenance lock when you export/import using phpMyAdmin. Problems may appear in situations as described by @amoun, when you have not deleted all the tables, for example. So, if you need to do this kind of restoration, make sure that the site is offline and drop all the tables from the database before to perform the import.

Just try to make sure that the backup file is complete before to drop the tables, maybe a local test would be a good idea.

Regards!

@amoun wrote earlier:

Hi pnair39, Just to give everyone what I am doing is running it locally under MAMP. I am importing the database to a new blank database, so I would assume no table dropping is required? "B2evolution when backing up database does not produce the write tables". So what I ended up doing is backing up directly for phpmyadmin and everything works.

What I am trying to figure out is when "B2 Maintenance backup area" doesn't use phymyadmin to do the backup?
========================================================================================

Just tried as I did push for an inbuilt option.

I didn't see an option in phpMyAdmn to directly restore/import the remote backup so I copied it by ftp to my local machine and then imported it.

The obvious issue was an import error that said

#1050 - Table 'evo_antispam' already exists

which isn't that surprising as I didn't drop all the tables before import.

So next to drop the tables and try again.

Ok that didn't work as one table didn't drop probably as I was still browsing the site and didn't put it in maintenance mode,it stopped when it found a pre-existing table. So i logged out of my site and dropped the tables again, this time they all went.

Import seemed successful but when I go to my site it says [evo.sessions] doesn't exit and sure enough in phpMyAdmin there is no such table.

So I am about to import my phpMyAdmin backup.

OK I'm bck up and running on my site Phew!!

It seems the internally backed up database was missing 5 tables 68 of 73 where imported but I haven't checked to see which, apart from the one mentioned in the error [evo.sessions]

All the best :)

mgsolipa wrote:

Problems may appear in situations as described by @amoun, when you have not deleted all the tables, for example.

However I also noted that the database download by the back-office option was short of 5 tables.