restoring data into mysql

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
i did  "select * into outfile 'data.sql' from CDRS" to backup my data.
what is the reverse to get the data back in? it looks liek the fields
are delimited by tabs in the file.


Re: restoring data into mysql

Quoted text here. Click to load it


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...

Bill K.

Site Timeline