Database backup requires attention to the database

1, phpMyAdmin cannot export the Big data table

If you have hundreds of data tables in your database, and you have a lot of data table records that are more than 1G, there are many InnoDB data tables, this time with phpMyAdmin export, you will find that after recovery, there may be only one or two tables

2, INNODB data Sheet special treatment

InnoDB data table directly copy database directory of the data directory can not be copied, generally in the database home directory of the ibdata1 file to keep records, in the copy of the file only the data table structure, there is no record, this is to be noted. Otherwise, many backup copies will not work at all.

3. Export method

Therefore, we use phpMyAdmin Export, Navicat import time after checking whether the data table has 0 records of the data table, so we will be easy to check the problem, otherwise it is likely to wait until we think that all the import and then a recovery of the database data table all gone. Mk_comic,mk_user,mk_readed.sql,mk_readnum.sql These data tables are INNODB data tables, I was later a separate export, and limit the number of export records to 1000 before exporting.

4. About rewriting

<virtualhost *:80>
ServerName test.mkzhan.com
DocumentRoot "D:/apmserv5.2.6/www/htdocs/mkzhan"
<directory "D:/apmserv5.2.6/www/htdocs/mkzhan" >
Options Indexes FollowSymLinks
DirectoryIndex index.html index.htm default.htm index.php default.php index.cgi default.cgi index.shtml index.aspx Default.aspx
AllowOverride All
Order Allow,deny
Allow from all
</Directory>
<ifmodule mod_rewrite.c>
Rewriteengine on
Rewriterule ^/(. *). html$/index.php/$1
Rewriterule ^/(\d+)/?$/index.php/comic/show/id/$1/
Rewriterule ^/(\d+)/(\d+)/?$/index.php/read/index/comicid/$1/id/$2/
</IfModule>
</VirtualHost>

I set up the. htaccess in the root directory and found that the rewrite was unsuccessful and was found to be successful in the Apache Virtual host directory D:\APMServ5.2.6\Apache\conf\apmserv\vhost.conf

4, Nginx and Apache rewrite rules are different, can not generalize