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
Dear all,
I have mysql 4.1.11 on my current server, i need my database restore another
server.. (another server mysql version is 4.1.11 same.)
And now... I just created new my database to new server following command:
CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE
latin5_turkish
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
I'm in need of a hotbackup solution that supports multiple instances on the
the same server. Currently, I'm dumping the databases nightly and would
like to know if anyone know of an alternative. I've tested innodb, but have
not had any success getting it to work with more than one group(mysqld[GN
- Original Message -
From: "Leandro Melo" <[EMAIL PROTECTED]>
To: "lista mysql" <[EMAIL PROTECTED]>
Sent: Sunday, September 05, 2004 12:44 PM
Subject: Making database backup
> Hi,
> how can i make a back of the data in my database?
>
> I don
On Sunday 05 September 2004 11:44 am, Leandro Melo wrote:
> Hi,
> how can i make a back of the data in my database?
check out mysqldump
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: "Nothing fails like prayer." -- Ann
Hi,
how can i make a back of the data in my database?
I don't want the backup of the database itself, i only
want a backup that will give a script to insert all
the data i currenlty have (only the inserts).
I'm also using mysqlcc, if there's any facility.
Thanks,
Leandro.
"Scott Fletcher" <[EMAIL PROTECTED]> wrote:
> Is it possible to verify the database backup. Like most machines, that
> make backup of files then verify that all of it is backed up without an
> error? I use mysqldump to make a backup but I have no idea about the
>
Is it possible to verify the database backup. Like most machines, that
make backup of files then verify that all of it is backed up without an
error? I use mysqldump to make a backup but I have no idea about the
verify
Thanks,
Scott
On 02/25/2004 09:13 AM Frederic Wenzel wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
In my opinion,
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED]
wrote:
>
> 1. database backup.
> This is done on the standby one with the following command.
> mysqldump --opt --quote-names --flush-logs database_name > database.backup
How does this operations handl
Fred, Jim,
Thank you very much for your kind help! I still have other questions about the MySQL
operation.
If a service host is redundant, one is in active status, the other is standby. I want
to make the following operation .
1. database backup.
This is done on the standby one with the
-
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED]
> Subject: Re: A question about mysql database backup.
>
>
> Li, Lenny Yong Bo (Lenny) wrote:
>
> > Now I am
Li, Lenny Yong Bo (Lenny) wrote:
> Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
> want to make sure whether the following procedures are correct for database backup.
> 1. mysqldump -F --opt database_name > database_name.backup
In my opinion
Ms./Sir,
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
2. stop mysqld if is running. Then start it with "-
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
estion but since it refers to a MySQL
> database I thought I would ask here.
> I may not be looking in the right places but, I can't seem to find a
> way to do a database backup through PHP (other than BACKUP TABLE,
> which I don't want to use if possible)
>
> What I
This is actually more a PHP question but since it refers to a MySQL
database I thought I would ask here.
I may not be looking in the right places but, I can't seem to find a way
to do a database backup through PHP (other than BACKUP TABLE, which I
don't want to use if possible)
What
would mean a second
copy of MySQL
but you would only need a low spec system..
I hope this helps...
Simon
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 21:37
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without
not quite sure what you mean by locking.
each table will be locked during "readout" for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
PROTECTED]]
Sent: Tuesday, March 19, 2002 1:37 PM
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when running my
On windows, I copy the 2 MYD MYI of a database to
another directory as a way of
backup. It seems to function properly.
I just want to know if the same file exists on HPUX
and if I can do the same thing.
Any help appreciate.
Thanks.
__
Do 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
I copy the 3 MYD MYI frm of a database to another directory as a way of backup.
Is this the right way to do it. It appears to be not function correctly.
Any help appreciate.
Thanks.
Hello,
could anyone explain me how to backup and in case of system crash
restore
the mysql database (main database where data about other databases,
grants,users, etc. is kept)?
Thanks in advance !
Regards,
Saulius Gurklys
mailto:[EMAIL PROTECTED]
--
30 matches
Mail list logo
