Differences

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

--- programming:mysql:mysql [2019/05/24 09:48] – maferreira
+++ programming:mysql:mysql [2019/10/11 09:34] (current) – [Export database] maferreira
@@ Line 5: / Line 5: @@
 ===== Export database =====
-  mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql
+With data:
+<code mysql>mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql</code>
+Without data:
+<code mysql>mysqldump --no-data -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';