Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 1, 2006, 7:22 pm
rate this thread
Re: restoring data into mysql
"LOAD DATA INFILE"
Are you aware that mysqldump can back up individual tables? I know you said
in a past thread that your database is large (~250GB) but you can use
mysqldump in a manner similarly to your "into outfile" usage -- to back up
one table at a time.
You can also use a shell pipe to compress the output of mysqldump before it
writes it to disk. For example:
mysqldump ...options... | gzip > mybackup.sql.gz
Then uncompress it during restore:
gzcat mybackup.sql.gz | mysql ...options...
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum