MYSQL problems please help me! somebody! - GoFuckYourself.com

x2dio · 01-01-2004, 06:46 PM

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 - · 01-01-2004, 06:47 PM

I will tell you....

for one million dollars.

CS-Jay · 01-01-2004, 06:48 PM

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 - · 01-01-2004, 06:48 PM

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

Quote:

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 · 01-01-2004, 06:49 PM

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

Mr.Fiction · 01-01-2004, 06:51 PM

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

- Jesus Christ - · 01-01-2004, 06:51 PM

Quote:

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

Beer makes dumb, eat musroom.

JamesK · 01-01-2004, 06:53 PM

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 · 01-01-2004, 06:54 PM

And good luck

CS-Jay · 01-01-2004, 06:54 PM

Quote:

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 · 01-01-2004, 07:18 PM

Quote:

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 · 01-01-2004, 07:19 PM

Quote:

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 · 01-01-2004, 07:48 PM

Quote:

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 · 01-01-2004, 07:51 PM

Quote:

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 · 02-07-2004, 03:10 PM

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 · 02-07-2004, 03:56 PM

01-01-2004, 06:46 PM	#1
x2dio Confirmed User Join Date: Jun 2003 Posts: 101	MYSQL problems please help me! somebody! 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 __________________ <hahahahaha src="http://www.x2dio.com/sig/sig.swf" quality=high type="application/x-shockwave-flash" width="100" height="100" menu="false"></hahahahaha><br><br>x2dio.com - Design Overload - Coming Soon<br> 203814376

01-01-2004, 06:47 PM	#2
- Jesus Christ - Confirmed User Industry Role: Join Date: Mar 2003 Location: ::::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: ::::::\|\|\|\|\|\|\|\|\|\|\|\|:::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::::::::::::::: Posts: 7,197	I will tell you.... for one million dollars. __________________ Amen

01-01-2004, 06:48 PM	#3
CS-Jay Confirmed User Join Date: Oct 2003 Location: Command Central, West Palm Beach, Fl Posts: 1,794	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 __________________ I do stuff - aIm CS_Jay_D

01-01-2004, 06:49 PM	#5
CS-Jay Confirmed User Join Date: Oct 2003 Location: Command Central, West Palm Beach, Fl Posts: 1,794	Man, I was way off. Must be the blood in my beer system. __________________ I do stuff - aIm CS_Jay_D

01-01-2004, 06:51 PM	#6
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	It's impossible to do, don't even try it! __________________ Don't be lazy, protect free speech: ACLU \| Free Speech Coalition \| EFF \| IMPA

01-01-2004, 06:53 PM	#8
JamesK hi Industry Role: Join Date: Jun 2002 Posts: 16,731	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 __________________ M3Server - NATS Hosting

01-01-2004, 06:54 PM	#9
JamesK hi Industry Role: Join Date: Jun 2002 Posts: 16,731	And good luck __________________ M3Server - NATS Hosting

02-07-2004, 03:10 PM	#15
x2dio Confirmed User Join Date: Jun 2003 Posts: 101	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? __________________ <hahahahaha src="http://www.x2dio.com/sig/sig.swf" quality=high type="application/x-shockwave-flash" width="100" height="100" menu="false"></hahahahaha><br><br>x2dio.com - Design Overload - Coming Soon<br> 203814376

02-07-2004, 03:56 PM	#16
x2dio Confirmed User Join Date: Jun 2003 Posts: 101	bump __________________ <hahahahaha src="http://www.x2dio.com/sig/sig.swf" quality=high type="application/x-shockwave-flash" width="100" height="100" menu="false"></hahahahaha><br><br>x2dio.com - Design Overload - Coming Soon<br> 203814376