How do I move a very large db?

[DSD]

I currently have a very large database on another site, with another hosting company and I would like to move my xmbforum to here (JaguarPC), but when I tried to move the db my browser keeps locking up and closing. I tried two different ways. One by downloading a backup of the db and the other by using the sql export feature.

The database I want to move is approx. 20mb.

Can someone help me with this issue? Any ideas on how I can go about moving this forum?

Thanks,
DSD

[Zhen-Xjell]

Most likely the upload limit with a web browser is far shorter than your db size. You'll need to transfer it via FTP or SCP instead.

[jason]

Refer to this thread....

--Jason

[DSD]

Where can I find msql documentation on command line instructions? I think I need to read this before I start.

Is this just as easy to do as uploading files via FTP to my site? Or, is this more complicated and complex?

Thanks,
DSD

[Zhen-Xjell]

man mysql
man mysqldump

[jason]

Also, check out the online docs at http://www.mysql.com. They are pretty helpful as well.

Your databse dump file should be a text file. Just upload it to your account as you would any file for your site, but don't put it in public_html. Also, make sure that you upload it as ASCII, not binary.

--Jason

[DSD]

I went to MySQL.com and I couldn't find any documentation on anything.

Am I looking in the wrong place?


----- Nevermind, I found some information....

[Zhen-Xjell]

Hi DSD, it is nice to post where you found the information so anyone in the future can refer to it.

[DSD]

I found the information on mysql.com. I don't have the exact url because my history folder doesn't work anymore. I didn't get a chance to save it in my favorites either, because I also came across a site that looked like it had some really good tutorials on it. But this particular site (vinuthomas.com) started installing something on my computer even though I said "no" to the little popup box. Don't go to vinuthomas.com, when I went there it started installing something called wreckit.cab on my computer without my permission. The main page seemed ok, but when I went to the links on tutorials, that's where the problem was. I disconnected from the internet and closed all open windows to stop the download.

Question for Jason or whoever has an answer for me:

If I'm not supposed to upload my file to public_html, where should I upload it to? Which directory?

Thanks!

[jason]

Originally posted by DSD
Question for Jason or whoever has an answer for me:

If I'm not supposed to upload my file to public_html, where should I upload it to? Which directory?

Thanks!

Well, anywhere you want...

For temporary stuff that I'm going to delete shortly after I upload it, I usually just put it in my account's root, the directory you enter by default when you log in with ftp. This makes its easy to find the files when you go to use them. Since you don't need to keep that DB dump once you create the new DB, I'd just put it there, then run the mysql commands, verify that the DB is created correctly, then delete the dump file.

For stuff I plan on keeping for a while, I have several places where I put things. For example, I use a directory called "bin" where I keep scripts and programs that I install that I don't want web users accessing directly. I also have directories for my web templates and include files that I don't want web users stumbling upon.

--Jason