MYSQL problems please help me! somebody!

[x2dio]

Hi I have a .sql file I need to import into a mysql Db, the problem is I cannot do it thru MYPHPADMIN because the file is too big and my browser locks up.

how can I do this thru ssh??


someone plz

[- Jesus Christ -]

I will tell you....




for one million dollars.

[CS-Jay]

if my memory servers me:

mysql -p databasename > datebasenamefile.sql

and you have to create the database first.

I don't have my files at home, but I think that's right.

J

[- Jesus Christ -]

Ok the one million dollar paypal pament you made (after we arranged the details over ICQ) has been recieved.


mysql -uUSERNAME -p newdbname < /path/to/dump.sql

Originally posted by CS-Jay
if my memory servers me:

mysql -p databasename > datebasenamefile.sql

and you have to create the database first.

I don't have my files at home, but I think that's right.

J

STOP TRYING TO FUCK WITH MY BLING!

EVEN THOUGH YOU ARE WRONG!

[CS-Jay]

Man, I was way off. Must be the blood in my beer system.

[Mr.Fiction]

It's impossible to do, don't even try it!

[- Jesus Christ -]

Originally posted by CS-Jay
Man, I was way off. Must be the blood in my beer system.

Beer makes dumb, eat musroom.

[JamesK]

Ok listen up.

First create a new database in MyPHPAdmin.

Then use telnet/ssh and connect to your server (if you don't have access, contact your host and ask them for access).

Upload the .SQL file with FTP/Telnet to the root and then type this in telnet/ssh:

mysql -u username -p newdbname < nameofdb.sql

username = mysql username
newdbname = the name of the db you just created in MyPHPAdmin

[JamesK]

And good luck

[CS-Jay]

Originally posted by - Jesus Christ -
Beer makes dumb, eat musroom.

I had mushrooms on my pizza, but I drank beer....don't those two just cancel each other out?

[x2dio]

Originally posted by Wildcard
Ok listen up.

First create a new database in MyPHPAdmin.

Then use telnet/ssh and connect to your server (if you don't have access, contact your host and ask them for access).

Upload the .SQL file with FTP/Telnet to the root and then type this in telnet/ssh:

mysql -u username -p newdbname < nameofdb.sql

username = mysql username
newdbname = the name of the db you just created in MyPHPAdmin

Worked Beautifully!

THANKS!

[JamesK]

Originally posted by x2dio




Worked Beautifully!

THANKS!

Np I had a shitload of trouble with it before. I know how fucking annoying it is. That's the only reason I'm helping you

[fuzebox]

Originally posted by CS-Jay
if my memory servers me:

mysql -p databasename > datebasenamefile.sql

and you have to create the database first.

I don't have my files at home, but I think that's right.

If you don't know, you shouldn't answer.

Had that been his only copy of that sql dump, it would have been wiped out.

[Ben-MensNiche]

Originally posted by CS-Jay
if my memory servers me:

mysql -p databasename > datebasenamefile.sql

and you have to create the database first.

I don't have my files at home, but I think that's right.

J

That dumps the database to a .sql file named databasefilename.sql you need the pipe the other way around.

mysql -p databasename < databasenamefile.sql

[x2dio]

Hey guys

im trying to do this again now, and it seems like everything is copying over with no errors..

but when I got to check the database there is no data in it??

has that ever happened to anyone?

[x2dio]

bump