Backup Database - no tables found

Permalink
When trying to import the sql file provided from the Dashboards "Backup Database", phpMyAdmin comes back with "no tables found in database". Any ideas?

I've gotta say the last few updates have been nothing but problems and I'm quickly losing patience with Concrete5. I have lost control of matching my local version with what my client is using online because of these problems.

 
MattWaters replied on at Permalink Reply
MattWaters
Hi vapor9,

When you ask concrete5 to make a new database backup, do you get any error messages? The issue we commonly see with this feature is that the backup takes longer than your local PHP process time limit allows (often 30 seconds). This kills the process and you'll see and error like: "Maximum execution time of N seconds exceeded". It's a very common limitation, especially on shared hosting environments.

In general I'd recommend using phpMyAdmin or similar to make a database backup manually. See this how-to, under the heading "Backup a database using phpMyAdmin":

http://www.concrete5.org/documentation/how-tos/developers/backup-a-...

Of course you can always do a manual db dump from the command line, if you're comfortable:

mysqldump -u username -p databasename --skip-lock-tables > db_dump.sql


Hope that helps!