Move Classipress to a new server
Hello,
I moved a test version of my website to my new server to see if everything works.
Export and Import of database worked without any problem.
1. Open phpMyadmin
2. exporting tables from "database_name" database
3. Choose: Custom - display all possible options
4. I changed: Database system or older MySQL server to maximize output compatibility with:
NONE to
MYSQL40
(Info in case someone have problems with import)
The other problem is that the template seems destroyed and the settings of classipress are not saving.
I fixed this (I think) by changing the name of the theme for example from classipress to classipress1 and then rename back to default.
I'll see tonight if this is really working, because I tried 2 more things with it and I don't remember which fixed this issue.
Now, I used a script to repair and optimize my database and it found the following errors.
This is strange to me because I had no errors when I imported the database. So here I need some help to fix this.
Code:
The wp_cp_coupons table is not okay. It is reporting the following error: Table 'vintagetoys_wpls.wp_cp_coupons' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_cp_coupons table. Error: Table 'vintagetoys_wpls.wp_cp_coupons' doesn't exist
The wp_cp_order_info table is not okay. It is reporting the following error: Table 'vintagetoys_wpls.wp_cp_order_info' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_cp_order_info table. Error: Table 'vintagetoys_wpls.wp_cp_order_info' doesn't exist
Code:
wp_cp_ad_packs: Table 'vintagetoys_wpls.wp_cp_ad_packs' doesn't exist
wp_cp_coupons: Table 'vintagetoys_wpls.wp_cp_coupons' doesn't exist
wp_cp_order_info: Table 'vintagetoys_wpls.wp_cp_order_info' doesn't exist
Thank you.