Differences

This shows you the differences between two versions of the page.

--- programming:mysql:mysql [2019/05/24 09:48] – [Export database] maferreira
+++ programming:mysql:mysql [2019/05/24 09:51] – [Import database] maferreira
@@ Line 6: / Line 6: @@
 ===== Export database =====
 <code mysql>mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql</code>
 ===== Import database =====
-  mysql -u username -p database_name < file.sql
+<code mysql>mysql -u username -p database_name < file.sql</code>
 <note important>Make sure you have created an empty database named <data_basename></note>
-  mysql> create database myDatabase;
+<code mysql>mysql> CREATE DATABASE <myDatabase>;</code>
   Query OK, 1 row affected (0.01 sec)
 ===== Create user =====
-  CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
+<code mysql>CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';</code>
   mysql> grant usage on *.* to myUsername@localhost identified by 'myPassword';