Hi,
Maybe you will have better luck with a command like:
mysqldump -u user -ppassword databasename > backup_date.sql
Regarding phpmyadmin, my guess would be, the script is longer
than the permitted time to finish.
Defaults in php.ini is something like:
max_execution_time = 30 ; Maximum execut
Richard, there's no inherent problem around 60 MB - I routinely dump data
ranging from a few KB to a few GB.
One thing I note is that you are using the mysql command, which is the
interactive database client. You want to use mysqldump, the client program
that dumps data from the database in SQL
Hello, I've got a problem with mysql 5 on my debian server.
I've got a forum on this server and untill the database reached about 60
Mo I could dump the database with either phpmyadmin or with the command :
mysql -u user -p'password' databasename > backup_date.sql
My last backup that worked w
Just checking if this user has "RELOAD PRIVILEGES", as it is needed for the
--master-data option which is automatically enabled with
--delete-master-logs , does the error duplicate on subsequent attempts ??
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 3/31/06, Cody Holland <[EMAIL
I recently migrated all of our mysql databases from 4.1.X to 5.0.X.
Everything is working properly except my backups. Here is the command
that I am using:
mysqldump -u user -ppassword --opt -A -F --delete-master-logs | gzip >
$BACKUPFILE`date +%m%d%y`.sql.gz
This worked on the old database serve
