Differences

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

--- programming:mysql:mysql [2017/10/04 13:03] – kroduit
+++ programming:mysql:mysql [2019/10/11 09:34] (current) – [Export database] maferreira
@@ Line 4: / Line 4: @@
   Enter password:
-  mysql> create database myDatabase;
+===== Export database =====
+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 =====
+<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>
+<code mysql>mysql> CREATE DATABASE <myDatabase>;</code>
   Query OK, 1 row affected (0.01 sec)
+===== Create user =====
+<code mysql>CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';</code>
   mysql> grant usage on *.* to myUsername@localhost identified by 'myPassword';
@@ Line 84: / Line 96: @@
   $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
 For more info see http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
+If this error,
+<note warning>ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'</note>
+<note tip><code mysql>mysql>SET GLOBAL show_compatibility_56 = ON;</code>
+To keep variable always ON even if you restart the server, create file my.cnf
+Read :
+http://mysql-tools.com/home/1-mysql/125-showcompatibility56-mysql-57-connection-problem.html
+</note>
 <code mysql>