Re: database backup problem, since database over 60mb

2007-04-11 Thread Mogens Melander
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

Re: database backup problem, since database over 60mb

2007-04-11 Thread Dan Buettner
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

database backup problem, since database over 60mb

2007-04-11 Thread Richard
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