homepage Welcome to WebmasterWorld Guest from 54.163.72.86
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
400 MB SQL Database Storage
How to tranfer a database to another machine
aff_dan




msg:1578479
 4:36 pm on Jan 2, 2006 (gmt 0)

Hi Sirs/Madam,

I have a problem. I have a 400 MB SQL Database Storage, on my computer. This is huge.

I want to transfer it to my server, in a datbase machine from my Web site. WHAT DO DO?

Please help

Regards,
Dan

 

kullervo




msg:1578480
 4:43 pm on Jan 2, 2006 (gmt 0)

Dump it as SQL in a file and compress it. If it's a MySQL database it's easier and a lot faster to do a cold copy of the database files. Personally, I wouldn't trust an answer from a random guy. I would like to read it myself in the manual.

anjanesh




msg:1578481
 4:53 pm on Jan 2, 2006 (gmt 0)

If the sql file is 400 MB and then using
mysql < filename.sql
would do the job of importing.
But is it possible to import a zipped file like
mysql < filename.sql.zip
or mysql < filename.tar
?

john_k




msg:1578482
 4:55 pm on Jan 2, 2006 (gmt 0)

What kind of database is it? (mySql, MS SQL Server, etc.)

kullervo




msg:1578483
 5:22 pm on Jan 2, 2006 (gmt 0)

anjanesh:
Pipe the output from tar, unzip, gunzip or bunzip2 to mysql. Ie. mysql < gunzip -c database_backup.sql.bz
The -c argument is for:
"-c --stdout --to-stdout
Write output on standard output; keep original files unchanged." - gunzip's manpage.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved