Trying to import a Modx Mysql file from one host to another, and get following message:
#1050 - Table ’active_users’ already exists (I do not suceed in getting the data transferred). Using phpMyAdmin
I have backed up the MySql data through ModX manager on the other server.
I succeeded in installing ModX on the new server. Now I would like to make a dump of all the content from the old one.
I have through ftp uploaded all files from the old server - and changed the config file so that it has the information from the new server.
Why am I getting the table already exist fault? And how come I cant import the data through PhpMyAdmin? Do I have to delete all the content created automtically from installing ModX in order to get the data imported correct?
Looking forward to hear from you!?? I am sure this will be simple for you???
The solution was to Delete all tables from the database, and import the sql data from ModX. - Now it works exactly as intended!