How to export and import databases

18秒

SHARE

To export a database in mysql

/opt/local/lib/mysql5/bin/mysqldump -u root storyauc > storyauc.sql

(For mac)

Refer to the website at %E8%

To import

After defining the following in mysql beforehand,

CREATE DATABASE storyauc CHARACTER SET utf8

Just type in the following

mysql -u root storyauc < storyauc.sql

前の記事

vi command

次の記事

Sakura VPS