question error MySql

diskman_iia · October 25th, 2004, 3:36 PM

hi, I am trying to install a data base by means of SSH and it sends east error to me what can i do?

mysql -u root -e Octubre <12_Octubre.sql

ERROR 1064 at line 1

**patrickb** · October 27th, 2004, 10:29 PM

Not too sure about this. First thing is first, make sure you have a root password set in mysql. Otherwise you are at a severe security risk level.

Secondly, if it is a .sql file, don't use the -e Octubre part. Instead, use something along the lines of:

mysql databasename < Octubre.sql

That is all you should need. Also make sure the database itself is already created and setup.

October 25th, 2004, 3:36 PM	#1 (permalink)
diskman_iia Registered User Fresh Surpasser Joined in Oct 2004 Lives in valpo 6 posts Gave thanks: 0 Thanked 0 times	question error MySql hi, I am trying to install a data base by means of SSH and it sends east error to me what can i do? mysql -u root -e Octubre <12_Octubre.sql ERROR 1064 at line 1

October 27th, 2004, 10:29 PM	#2 (permalink)
patrickb the one who was Super #1 Joined in Jul 2003 Lives in Memphis 1,967 posts Gave thanks: 0 Thanked 3 times	Not too sure about this. First thing is first, make sure you have a root password set in mysql. Otherwise you are at a severe security risk level. Secondly, if it is a .sql file, don't use the -e Octubre part. Instead, use something along the lines of: mysql databasename < Octubre.sql That is all you should need. Also make sure the database itself is already created and setup. __________________ Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)