[ Date Index ][
Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
On Tuesday 05 October 2004 6:14 am, Richard Brown wrote:
Since I am using Mac OS X I don't have the tools I would have used under Linux. It shouldn't matter because X is bsd based anyway!
If you've got a connection to the MySQL server, you've got all the tools you need. I don't see why you want to use a script though. mysql -p dbname < file.sql should be sufficient. $ mysql -u rocheafc -p rocheafc < rocheafc.sql Enter password: It's common to have a database name based on the login name but it does make it confusing. I tend to use a prefix to make it clearer. $ mysql -u rocheafc -p db_rocheafc < file.sql Always test your SQL file locally. Create a temp database and import the data there. If you get any errors, your syntax in the sql file is wrong - no matter where it came from, if it generates a syntax error, the contents of the file are wrong. Make sure the sql file contains instructions to build any tables that don't exist already. Test the SQL content in phpmyadmin - that'll show you where the errors lie. Again, create a temporary database with no tables and copy the SQL into the query box. You'll soon see the error.
Any ideas. I could enclose a copy of the sql file if someone wouldn't mind looking at that.
MySQL will tell you where the error is occurring so just post the two or three commands either side. -- Neil Williams ============= http://www.codehelp.co.uk/ http://www.dclug.org.uk/ http://www.isbn.org.uk/ http://sourceforge.net/projects/isbnsearch/ http://www.biglumber.com/x/web?qs=0x8801094A28BCB3E3
Attachment:
pgp00009.pgp
Description: PGP signature