Apologies for empty post!
Stuart Bird wrote:
Can anyone give me a step by step guide as to how to proceed.
mysql -usomeuser -p somedatabase < somefile.sql
.. where someuser is the mysql user you want to use (much have the
correct access rights), somedatabase is the name of the database, and
somefile.sql the file you're importing.
You'll be asked for your mysql user's password (that's what the -p
prompts for).
I would *strongly* advise looking at the SQL file first and sanity
checking it. All the above will do is connect to mysql, select the
"somedatabase" database, and then run the commands in the file as if you
typed them at the mysql command line.
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
