1.use mysqldump to dump table structure without data
mysqldump -u root -pabc123 -d --databases EbookStore > 20110328.sql
2011年3月28日 星期一
create table structure from another database
1.login to mysql database;
2.use create table tablename as select * from dbname.tablename;
use BookStore;
create table newBook as select * from OldBookStore.newBook;
2.use create table tablename as select * from dbname.tablename;
use BookStore;
create table newBook as select * from OldBookStore.newBook;
2011年2月14日 星期一
fix mysql upgrade
1.after your migration mysql from old version to new version
you can use mysql_upgrade command to force upgrade to new version with schema
#mysql_upgrade -u root -pgreen@123
3.check mysql all tables
#mysqlcheck --check --all-databases -u root -pgreen@123
3.check and fix mysql all tables
#mysqlcheck --check-upgrade --all-databases -u root -pgreen@123
4.update all privilege table
#mysql_fix_privilege_tables -u root --password=green@123 --verbose
you can use mysql_upgrade command to force upgrade to new version with schema
#mysql_upgrade -u root -pgreen@123
3.check mysql all tables
#mysqlcheck --check --all-databases -u root -pgreen@123
3.check and fix mysql all tables
#mysqlcheck --check-upgrade --all-databases -u root -pgreen@123
4.update all privilege table
#mysql_fix_privilege_tables -u root --password=green@123 --verbose
how to repair table
1.use mysqlcheck to repair one table
#mysqlcheck -r mytable username -u root -pgreen@123
2.use repair table command
#mysql -u root -pgreen@123
->use mytable
->repair table username
#mysqlcheck -r mytable username -u root -pgreen@123
2.use repair table command
#mysql -u root -pgreen@123
->use mytable
->repair table username
2010年9月7日 星期二
use subquery to insert data
mysql>insert into persons values('tommy','lin','22','male');
insert one record to table persons
mysql>insert into customers(lastname,firstname) select lastname,firstname where age=22 and sex='male' from persons limit 1;
use subquery to get data that insert into another table customers
insert one record to table persons
mysql>insert into customers(lastname,firstname) select lastname,firstname where age=22 and sex='male' from persons limit 1;
use subquery to get data that insert into another table customers
install mysql server on ubuntu
#apt-get update
#apt-get upgrade
update and upgrade the current os packages
#apt-get install mysql-server mysql-client
install mysql-server and client package
#mysql -u root -p
mysql>select version();
confirm the installion version of mysql
mysql>show databases;
show all databases you can access with your privileges;
mysql>use mysql;
use mysql database;
mysql>show tables;
show all tables with this database mysql
#apt-get upgrade
update and upgrade the current os packages
#apt-get install mysql-server mysql-client
install mysql-server and client package
#mysql -u root -p
mysql>select version();
confirm the installion version of mysql
mysql>show databases;
show all databases you can access with your privileges;
mysql>use mysql;
use mysql database;
mysql>show tables;
show all tables with this database mysql
訂閱:
文章 (Atom)