mysql nerds - GoFuckYourself.com

Chris · 10-30-2006, 08:08 AM

if your at the mysql console what is the command to import a .sql file locally like if the .sql file was on the same computer

StuartD · 10-30-2006, 08:10 AM

source file.sql

teksonline · 10-30-2006, 08:10 AM

ctrl-v for paste hehe

we do mysql -u<user> -p <dbname> <blah.sql

b3ck · 10-30-2006, 09:54 AM

hey that question was asked by me thru chris, just wanted to let you all know that it worked and it was a lot faster than doing it thru navicat, I was able to load a 184 mb database in less than 5 mins with the mysql console, rather than 12+ hours thru navicat it was still going on well after the mysql console was finished... Thanks again all =)

-b3ck

gooddomains · 10-30-2006, 09:58 AM

sql *****

b3ck · 10-30-2006, 10:01 AM

sql what???

10-30-2006, 08:08 AM	#1
Chris Too lazy to set a custom title Industry Role: Join Date: May 2003 Location: icq: 71462500 Skype: Jupzchris Posts: 27,880	mysql nerds if your at the mysql console what is the command to import a .sql file locally like if the .sql file was on the same computer __________________ [email protected]

10-30-2006, 08:10 AM	#2
StuartD Sofa King Band Join Date: Jul 2002 Location: Outside the box Posts: 29,903	source file.sql __________________ This is me on facebook This is me on twitter

10-30-2006, 08:10 AM	#3
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	ctrl-v for paste hehe we do mysql -u<user> -p <dbname> <blah.sql

10-30-2006, 09:54 AM	#4
b3ck Registered User Join Date: Jan 2005 Posts: 4	hey that question was asked by me thru chris, just wanted to let you all know that it worked and it was a lot faster than doing it thru navicat, I was able to load a 184 mb database in less than 5 mins with the mysql console, rather than 12+ hours thru navicat it was still going on well after the mysql console was finished... Thanks again all =) -b3ck

10-30-2006, 09:58 AM	#5
gooddomains Too lazy to set a custom title Join Date: Jul 2003 Location: Netherlands Posts: 10,127	sql *****

10-30-2006, 10:01 AM	#6
b3ck Registered User Join Date: Jan 2005 Posts: 4	sql what???