Downloading Huge Database

[Polo]

I have a big database and I want to download it to my local computer.. .. i have tried downloading it using phpmysql, ,however, I think the database is too big or something because it wont download from my cpanel...

anyways, I went ahead and read alittle bit about putty and how it works, downloaded it and run it..

logged in and i think is working... I got the following:

-jailshell-2.05b$

however, I dont know what to do now..

can someoen help me?

[the_ancient]

have you had shell access enabled?

I dont use shell so I cant help you more than that...

there are Mysql Tools though that will allow you to do that with out shell as well, I personally use Navicat but it is a Pay for use product there are free ones out there, less advanced, but will do basic backups with no problems

[tank]

yes he has shell, that is wha the prompt is.

at that prompt enter in:
mysqldump --opt -p DBpasswordHere -u DBusernameHere -B DatabaseNameHere > database.sql

That will dump the database to a file called database.sql and put it in your root directory. you can then download it via your FTP client.

do some searche on mysqldump and you'll find plenty of infor about it.

[Polo]

thank you tank

[Polo]

Like this:

mysqldump --opt -p DBmydbpassword? -u DBmydbusername? -B databasename? > database.sql ?

or like this:

mysqldump --opt -p mydbpassword? -u mydbusername? -B databasename? > database.sql ?

and which passwords should I use? the database passwords? or the cpanel password?

[jason]

Use the second, although I'm pretty sure that you can't have spaces between the -u and -p (I may be wrong, but I know it works fine without them in there). Also, use the database username and password.

I've always used something like this:

mysqldump -ucpanelname_dbusername -pdbpassword cpanelname_dbname > dumpfile.sql

--Jason

[Polo]

Awesome got it working thanks jason. I will bookmark this thread now

[tank]

Yes without the spaces is the standard. I must have gotten spacebar happy. But I believe it will work regardless.

[Polo]

Ok, now that I downloaded my database using putty, how would I go about uploading it?? what would be the command? thanks in advance.

[Polo]

Ok, now that I downloaded my database using putty, how would I go about uploading it?? what would be the command? thanks in advance.

anyone?

[Ron]

(You're asking in a 14 month old thread....)

If by uploading it, you mean loading a sql dump file into the MySQL database, you need to ensure that the database is persent but all the tables are dropped, or that there are drop table commands in the sql file you previously created. DROPPING A TABLE IN MySQL DESTROYS ALL DATA ON THE TABLE. Please be sure of what you want to do before you do it.

If so, here is the command, I think:

mysql -h 127.0.0.1 -uusername -p < dumpfile.sql

You'll be prompted for your password.

If you mean how to upload the sql file to the server, I can't help you.

[Polo]

If so, here is the command, I think:

can someone confirm this?

[Ron]

ummm, did you try it?

[Polo]

ummm, did you try it?

no... what if that is not it, and I mess up something?? I'm not an expert with putty, so if I mess up something I wouldnt know how to fix it....

that is why I want to make sure that is correct....

[jason]

It looks correct to me. If it isn't you'll most likely end up with an error message, not a changed database. Ron knows his stuff. If he was worried that something he suggested could be problematic for you, he'd have told you (as he did in regard to DROPing tables).

The thing to remember is that the regulars around here that answer most peoples questions are just regualr hosting clients. I personally, and I'm sure I speak for others as well, stop in to read the boards a few times a day, when I have a few minutes to spare. When I provide advice, it is usually with the caveat that it hasn't been tested. I usually don't ahve the time to, for example, create a database with dummy database, dump it, and try to restore it. Instead I give an explanation that is as accurate as my memory of doing it before allows. Occasionally you might get an error message or two and have to do some figuring out on your own, but its that figure thing out that helps you learn and remember how to do it by yourself next time.

I don't mean for this to sound harsh. I just want you to realize that there is a risk that comes with all free advice. When you ask for such advice, you have to be willing to accept the risks, too.

--Jason