Appserv向XAMPP迁移

1.首先要将Appserv的innodb分文件储存，一个巨大的好处是直接拷贝文件可实现还原。参见这里http://blog.csdn.net/donglynn/article/details/45775739

2.将appserv的mysql/data目录备份

3.将AppServ的Apache/config备份，主要是Apache/config/extra/vhost.conf

4.将Appserv卸载

5.将备份mysql/data拷贝到xampp/mysql/data，但是不要覆盖

6.将Apache/config/extra/vhost.conf覆盖到xampp/config/extra/vhost.conf

7.将httpd.conf的如下内容修改解决403没有授权问题

<Directory />
 #   AllowOverride none #原内容
 #   Require all denied #原内容
    AllowOverride None
    Order deny,allow
    Allow from all
    Satisfy all
</Directory>

8.去MysqlAdmin将root用户设置密码，然后在config.inc.php中的$cfg['Servers'][$i]['password'] = '';设置为你的密码。

9.重启后Mysql会报错：

2015-05-25 02:25:06 1968 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace alibaba/order uses space ID: 2 at filepath: .\alibaba\order.ibd. Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd

解决办法很简单，删掉xampp\mysql\data中的innodb文件：

ib_logfile0

ib_logfile1

ibdata1

并且在配置文件中加入如下：

[mysqld]
innodb_force_recovery = 1

否则第二次启动会报错。

让Mysql重建即可。

10.You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

这里phpmyadmin文档是这么说的：

The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

特别需要注意的是post_max_size and memory_limit 要比 upload_max_filesize 设置的大，不然的话即使三个参数都设置的比较大仍然会提示该错误。