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
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
viewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: KH Chiu [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 9:19 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Database Backup Question
Sorry I am in a bit hurry and just post some hints on
Sorry I am in a bit hurry and just post some hints on your question. It is
more than one way to do your job. One of the trival way is to use php
function 'exec'. This function can execute shell programs. It means that you
can execute mysqldump etc. and create dump file.
>From my experience, you
This would be an acceptable method of backing up your databases, as long
as your server is not running at the same time you are doing this. If it
is, you risk corrupting your data. You should try one of the utilities
provided for making backups, mysqlhotcopy is a good one to do what you are
trying
