MyBB Community Forums

hello,

im trying to move from shared host to vps. but phpmyadmin gives error while importing database :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'File: /merge/resources/modules/users.php Line: 199 Function: Log->datatrace -> \' at line 14

using same phpmyadmin / mysql version as at my shared hosting but cant import sql via phpmyadmin...

importing only 22 tables to new database, not other tables

http://prntscr.com/cwnpoo

http://prntscr.com/cwnpsy

Please show the phpMyAdmin parameters you set when you export the database from the source server.

Edit: Since your destination server is a VPS, you can try to import the sql file directly from the command line.

Login as root on MySQL console, select the database you are using for MyBB (USE databasename;) and then type:

SOURCE /home/youruser/yourfile.sql

It's the same for windows, just different location:

SOURCE C:/yourfile.sql

Note: You must write full path, relative paths are not supported.

Yes, import it via the command line (even if on a local PC, then export it via the MySQL command line also)