( ) MySQL Databases
phpMyAdmin MySQL databases . , , ’ . phpMyAdmin , , SQL , ’ . , MySQL unavailability, HTTPD ’ .
MySQL , ’ , . MySQL ,, . ( ) ( ) MySQL databases() using mysqldump mysql utilities. MySQL, (*.frm, *.MYD, *.MYI ) using mysqlhotcopy , MyISAM . mysqldump MyISAM InnoDB .
, MySQL
MySQL , , . Telnet SSH dont’ .
mysqldump u username -p database_name > dump.sql
username MySQL ID, ( : p , mysqldump , ) database_name ) . , SQL , , dump.sql.
, , ) database_name SQL dump.sql .
MySQL
databases’ ( ), –- ’ . , :
mysqldump u username -p –- database_name > dump.sql
) MySQL
, –- - . , , - , , , , . databases , .
mysqldump u username -p –- - database_name > dump.sql
, MySQL Databases
databases– 1 . :
mysqldump u username -p –databases db_name1 [db_name2 ...] > dump.sql
, Databases MySQL
, databases, –-databases , databases’ anymore.
mysqldump u username -p –-databases > dump.sql
Online InnoDB
MySQL , using ) , . , , UPDATE ,, , MySQL . ’ using InnoDB, –- non- , online . coordinates , .
:
mysqldump u username -p –-databases – - > dump.sql
MySQL
phpMyAdmin, using . , upload , MySQL , databases MySQL .
mysql u username -p database_name <dump.sql
) MySQL , , , . , . ) mysqldump uses UTF8 , , , ( 4.1 ) , . , , UTF8 , ends , , ( Wordpress blog). , – ,- -setcharset_name= UTF8.
Entries (RSS)
26th, 2008 0132:
.. .. .. mysql ..
4th, 2008 1248:
-databases… ? … restoring msg: : -databases (Ive’ , ’ … ’ )
4th, 2008 1317:
mysql u p < -databases.sql
6th, 2008 0343:
mysqldump .
‘mysql’ . :
1: ‘\m’
- ?
16th, 2008 0246:
alot .. .. ,, .
14th, 2008 1631:
. , . Goog !
27th, 2008 2345:
, mysql ?
21st, 2008 0757:
[...] [...]