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
programming:mysql:mysql [2019/05/24 09:51] – [Import database] 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>
programming/mysql/mysql.1558691503.txt.gz · Last modified: 2019/05/24 09:51 by maferreira