I don't think Enterprise version solves this problem either. But you can slow down this by forcing MySQL to create each InnoDB table to its own...
CG01 provided you the right steps to save the data to database. You can find several online tutorials to achieve this, you just need to Google...
4 days are too much for just 3 million rows. Index the columns involved in JOIN i.e. 11.now, t2.ind_id, t1.cat_mod, t2.kitty_mod. This will speed...
It depends on your database size. Using phpMyAdmin is not feasible/possible with bigger databases. Use XtraBackup if you have a quite large...
This is a simplest How To to save records in MySQL.
You are welcome
For your first error you need to increase value for thread_stack in MySQL configuration file i.e. /etc/my.cnf. Restart the MySQL server after...
Which forum software you are using? Is the old database is also of the same forum software?
Yes, it is possible. You need to concatenate both fields in PHP and then insert to database.
In my opinion 4images is the culprit. You need to use some caching for this script.
Use phpMyAdmin on new host to import the SQL.
Are you sure you have the same data in your table? It is quite possible you have saved data in different format. Do you really have a matching...
Or you can use back ticks around the the column name like `serial number`
Then you should go for TRUNCATE but if you have AUTO_INCREMENT and think it might create problems by generating same ids again go for DELETE FROM...
Why you want to drop the database and then re-create it? It would be nice to truncate data of all tables instead of deleting tables. To drop a...
Separate names with a comma.
