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
Amir Bukhari wrote:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0
> -Original Message-
> From: Addison, Mark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 1:22 PM
> To: Amir Bukhari; mysql@lists.mysql.com
> Subject: RE: Backup problem from 5.0 to mysql 4.1
>
> From: Amir Bukhari Sent: 18 July 2006 09:23
> >
From: Amir Bukhari Sent: 18 July 2006 09:23
>
> I have local mysql 5.0 and I have developed an arabic site.
> The database
> encoding is utf8-bin. Localy everything work fine, all arabic text are
> displayed OK.
> Now I want to move it to a server in internet. The server has
> mysql 4.1 and
> a
I have local mysql 5.0 and I have developed an arabic site. The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has mysql 4.1 and
as I restored the database there, some special arabic character a
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
Hello List,
I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours
to restore.
the area where its really hanging is when its importing the "BLOB"
There are about 1200 records, totaling about 10mb in size for these blobs.
I am running MyISAM, my current memory settings read
At 12:27 AM 10/7/2004, you wrote:
This is what I need to do, what is the best approach for doing this?
I need to take backup of few tables in mysql, then I need to drop that
entire DB, recreate it, (and sth else that's not relevant here) and then
restore these backed up tables. This backup and rest
This is what I need to do, what is the best approach for doing this?
I need to take backup of few tables in mysql, then I need to drop that
entire DB, recreate it, (and sth else that's not relevant here) and then
restore these backed up tables. This backup and restoring should be as fast
as possib
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Binay --
Saw your post over in php-general but it's better over here :-)
...and then Binay said...
%
% Hi all !
Hi!
%
% I have two systems.
% one with mysql-version: 3.23.37
% other with mysql-version: 3.23.58
OK.
%
% now i want to take the
Hi all !
I have two systems.
one with mysql-version: 3.23.37
other with mysql-version: 3.23.58
now i want to take the backup of 3.23.37 data and copy to 3.23.58 ...
i know i can take backup using mysqldump command ... and then copy using mysql
commands
but as mysql create folder for ea
H M Kunzmann wrote:
>
> I use mysqldump to dump my databases to file.
> I then write these files to tape.
>
> I was doing a test restore to a test server this weekend and found that
> for my largest database, I cannot restore from this file.
>
> I use mysql < backup.script
>
> It runs for a lon
I use mysqldump to dump my databases to file.
I then write these files to tape.
I was doing a test restore to a test server this weekend and found that
for my largest database, I cannot restore from this file.
I use mysql < backup.script
It runs for a long time and creates most of the tables, bu
Hi Herbert,
the -f/--force option lets you continue with the next command
Thats my $0.0.2.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 28日 月曜日 17:57、H M Kunzmann さんは書きました:
> I use mysqldump to dump my databases to file.
> I then write these files to tape.
>
> I was doing a test restore t
I use mysqldump to dump my databases to file.
I then write these files to tape.
I was doing a test restore to a test server this weekend and found that
for my largest database, I cannot restore from this file.
I use mysql < backup.script.
It runs for a long time and creates most of the tables,
At 16:11 -0300 3/19/03, Dyego Souza do Carmo wrote:
Hi,
I am developing a mySql Backup software and I intend to develop two
different options for backup: Complete and Incremental, where Complete means
the full copy of a database, and Incremental means that only the log file
have to be copied
Hi,
I am developing a mySql Backup software and I intend to develop two
different options for backup: Complete and Incremental, where Complete means
the full copy of a database, and Incremental means that only the log file
have to be copied. The logic is the follow:
Once a week, my custo
hallo!
i have a backup-problem:
when i use
mysqldump -u michael -p --opt --all-databases > backup
i get the following error:
USE backup;
mysqldump: Got error: 1017: Can't find file: 'title.MYD' (errno: 2) when
using LOCK TABLES
but when i use
mysqldump -u michael -p --op
21 matches
Mail list logo
