MyBB Community Forums

Full Version: cant import mybb sql database !
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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
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)