Bolay's Wiki

User Tools

Site Tools

Trace:
programming:mysql:mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
programming:mysql:mysql [2019/05/24 09:50] – [Create user] maferreiraprogramming:mysql:mysql [2019/10/11 09:34] (current) – [Export database] maferreira
Line 5: Line 5:
  
 ===== Export database ===== ===== Export database =====
 +With data:
 <code mysql>mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql</code> <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 ===== ===== Import database =====
 <code mysql>mysql -u username -p database_name < file.sql</code> <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> <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)   Query OK, 1 row affected (0.01 sec)
  
programming/mysql/mysql.1558691452.txt.gz · Last modified: 2019/05/24 09:50 by maferreira