共 6 篇文章 |
|
MySQL数据库的数据备份和恢复详解 - 日志 - freebone - MySQL基地 ...使用以下 SQL 来备份 Innodb 表:root#/usr/local/mysql/bin/mysqlhotcopy -h=localhost -u=yejr -p=yejr db_name /tmp (把数据库目录 db_name 拷贝到 /tmp 下) root#/usr/local/mysql/bin/mysqlhotcopy -h=localhost -u=yejr -p=yejr db_name_1 ...db_name_n /tmproot#/usr... 阅107 转2 评0 公众公开 10-04-03 09:17 |
MySQL database on Linux Tutorial.mysql> CREATE DATABASE bedrock;Creates help database with SQL script: /opt/mysql/share/mysql/fill_help_tables.sql Start mySQL database: /opt/mysql/bin/mysqld_safe --user=mysql & /opt/mysql/bin/mysqladmin -u root password ''new-password'' /opt/mysql/bin/mysqlad... 阅353 转0 评0 公众公开 10-03-16 17:10 |
MySQL : create database, drop databasecreate database {db_name} default character set=utf8;drop database {db_name};Export: mysqldump -uroot -p --default-character-set=utf8 {db_name} > some.sqlImport: mysql -uroot -p --default-character-set=utf8 <some.sql. 阅274 转0 评0 公众公开 10-03-15 14:22 |