The best place to *find* answers to programming/development questions, imo, however it's the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but again, a great reference for *finding* answers.

My Music (Nickleus)

20110530

how to import/overwrite mysql database to a remote server using the command line

i installed tikiwiki on a domain i have hosted on domeneshop.no and they recommended not to use phpmyadmin, but mysql workbench instead. i wanted to import an old tikiwiki i had started 2 years ago. i used like an hour trying to setup mysql-workbench and kept getting the error:
ERROR 1046 (3D000) at line 22: No database selected
when all i really needed to do was open a terminal and run this:
mysql --host=myhost.example.com --user=myUser5 -p --default-character-set=utf8 myDbSchemaName < "/home/nick/sqlFileToImport.sql"

No comments:

Post a Comment