[ 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
-- The Mailing List for the Devon & Cornwall LUG Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the message body to unsubscribe.