Line 25: | Line 25: | ||
to import the database data (''wikilaussy-24-jan-10.sql'', a readable file with ''very long lines'') into the database structure (named ''wikilaussy'') above. | to import the database data (''wikilaussy-24-jan-10.sql'', a readable file with ''very long lines'') into the database structure (named ''wikilaussy'') above. | ||
+ | |||
+ | == Links == | ||
+ | |||
+ | * [http://blog.urfix.com/linux-command-line-mysql-awesome/] [[Linux]] command line and MySQL. |
Contents |
MySQL is the best database we know. That's what we use.
SHOW databases;
is may be the most important command. It shows you what's in store.
CREATE USER 'laussy' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON *.* TO 'laussy';
From the command line:
mysql -u laussy -p wikilaussy < wikilaussy-24-jan-10.sql
to import the database data (wikilaussy-24-jan-10.sql, a readable file with very long lines) into the database structure (named wikilaussy) above.