C:\ProgramData\MySQL\MySQL Server 5.7\mysql -u root -p [enter password] C:\ProgramData\MySQL\MySQL Server 5.7 show variables like 'datadir'; +---------------+---------------------------------------------+ | Variable_name | Value | +---------------+---------------------------------------------+ | datadir | C:\ProgramData\MySQL\MySQL Server 5.7\Data\ | +---------------+---------------------------------------------+
create database <databasename> default character set 'UTF8';
mysql -u <user> -p<password> mysql -u <user> -p<password> -v create database <database>; show databases; use <database>; show tables; select * from <table>;
mysqladmin -u root -p shutdown
<MySqlHomeDir>\MySQL Server 5.6\bin\mysqld --install
For Rails run this BEFORE TO CREATE table schema_info
$ rake db:migrate
SELECT * FROM dateitems INTO OUTFILE 'EXP_dateitems.dat'; [FIELDS TERMINATED BY ',' ENCLOSED BY '"'LINES TERMINATED BY '\r\n';9]=> creates a file under /var/lib/mysql/DatePlanner_development/dateitems.dat
mysql -h localhost -u <user> -p<password> DatePlanner_development SELECT * FROM dateitems INTO OUTFILE '/markus/workspace/DatePlanner/EXP_dateitems.dat'; SELECT * FROM dategroups INTO OUTFILE '/markus/workspace/DatePlanner/EXP_dategroups.dat'; SELECT * FROM users INTO OUTFILE '/markus/workspace/DatePlanner/EXP_users.dat';you need to give chmod 777 to the folder where to export, because it is done with user mysql
mysqldump -u <user> -p<password> DatePlanner_development dateitems dategroups users > 20090120_DatePlannerDB.sql mysql -u <user> -p DatePlanner_development < 20090120_DatePlannerDB.sql
mysqldump -u <user> -p<password> opencms > /anyfolder/20141012_opencms.sql mysql -u <user> -p<password> opencms < /anyfolder/20141012_opencms.sql mysqldump -u root -p --opt [database name] > [database name].sql mysql -u root -p newdatabase < /path/to/newdatabase.sql
Import in Windows also possible with MySql Workbench, see here
mysqldump -u <user> -p<password> homepage links > homepage.sql mysql -u <user> -p<password> homepage < homepage.sql
You can additionally pack/unpack
tar -zcvf archive-name.tar.gz sourceFolder tar -zxvf archive-name.tar.gz [-C /targetFolder]
mysql -u <user> -p<password> show databases; use <database>; show tables; mysqldump -u <user> -p<password> <table1> <table2> <...> > filename.sql Examples: mysqldump -u root -p<pw> DatePlanner_development dateitems dategroups users > 20100930_DatePlanner_development_DB.sql mysqldump -u root -p<pw> homepage links markers users > 20100930_homepage_DB.sqlImport
create database <databasename> default character set 'UTF8'; mysql -u root -p<password> DatePlanner_development < 20100930_DatePlanner_development_DB.sql mysql -u root -p<password> homepage < 20100930_homepage_DB.sql