Title: database error – Last modified: August 18, 2016 --- # database error – * Resolved [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/) * Ive suceeded on getting manfredeye.com tranfered. Now Im tring to upload the database information so as all my comments/posts/etc will come up. Im getting this error. * Error * SQL query: * CREATE TABLE `wp_ak_popularity` ( `post_id` int( 11 ) NOT NULL default ‘0’, ` total` int( 11 ) NOT NULL default ‘0’, `feed_views` int( 11 ) NOT NULL default‘ 0’, `home_views` int( 11 ) NOT NULL default ‘0’, `archive_views` int( 11 ) NOT NULL default ‘0’, `category_views` int( 11 ) NOT NULL default ‘0’, `single_views` int( 11 ) NOT NULL default ‘0’, `comments` int( 11 ) NOT NULL default ‘0’, `pingbacks` int( 11 ) NOT NULL default ‘0’, `trackbacks` int( 11 ) NOT NULL default ‘0’, ` last_modified` datetime NOT NULL default ‘0000-00-00 00:00:00’, KEY `post_id`(` post_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; * MySQL said: Documentation #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 ‘ENGINE=MyISAM DEFAULT CHARSET=latin1’ at line 14 * If there is anyone that can help me get my database information back I would so appreciate it! Viewing 9 replies - 1 through 9 (of 9 total) * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606875) * Is there any way that I can get some help please with this issue of regaining my comments/posts etc.? I have been waiting very patiently and doing many searches in the last 4hours. * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606918) * I did find this plug in. * WP-phpMyAdmin 2.8.2 * Provides phpMyAdmin from the WordPress admin console By Christopher Hwang. * I have installed it but it doesnt seem to work for me. Has anyone else tried this? * [microkid](https://wordpress.org/support/users/microkid/) * (@microkid) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606919) * Are you using phpMyAdmin to export? There might be a compitability problem between the MySQL version you’re exporting from and the one you are importing the data into. Compare the two versions. phpMyAdmin has the option to export the data in compatible formats for different MySQL versions (it’s on the export page). * Hope that helps. * [microkid](https://wordpress.org/support/users/microkid/) * (@microkid) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606920) * If you still can’t figure it out, you can try using the export/import functionality within WordPress. It should be under ‘manage’ in your wp-admin section, or there’s a plugin out there that makes it possible for older versions of WP. * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606922) * well I did find that I was exporting from 4.1.21 and importing on 4.0.16 but there seems there should be a way to keep all my info and upload it to my new blog. I really cant loose all that info. Im lost…lol * [microkid](https://wordpress.org/support/users/microkid/) * (@microkid) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-606986) * No, it only has to do with the structure of the export, you won’t lose any data. * But again, check out the export/import functionality within wordpress, it is the best solution to your problem. * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-607163) * I tried the wordpress function and that didnt work for me as I didnt export from my last standing blog. Im trying to export from MySQL and I just found that there seems to be a bug in the system. Some may find this interesting.For me nothing there worked for me. Im still in fear of not being able to restore all my comments/ posts [http://bugs.mysql.com/bug.php?id=14515](http://bugs.mysql.com/bug.php?id=14515) * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-607165) * ok nobody BREATHE! I finally was able to upload my file to phpMyAdmin and was able to fill the database. Now like Id said there was a bug, dont know if that had anything to do with it but after reading many many posts here I did this: * — phpMyAdmin SQL Dump — version 2.10.0.2 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)—— Host: localhost — Generation Time: Aug 19, 2007 at 06:53 PM — Server version: 4.1.22 — PHP Version: 4.4.4 * — — Database: `'your-DB-name'` — USER: ‘your-username’ — PASSWORD: ‘add-PW-here’ * ——————————————————– * — — Table structure for table `wp_ak_popularity` — * DROP TABLE IF EXISTS `wp_ak_popularity`; CREATE TABLE IF NOT EXISTS `wp_ak_popularity`(` post_id` int(11) NOT NULL default ‘0’, `total` int(11) NOT NULL default ‘0’, ` feed_views` int(11) NOT NULL default ‘0’, `home_views` int(11) NOT NULL default‘ 0’, `archive_views` int(11) NOT NULL default ‘0’, `category_views` int(11) NOT NULL default ‘0’, `single_views` int(11) NOT NULL default ‘0’, `comments` int( 11) NOT NULL default ‘0’, `pingbacks` int(11) NOT NULL default ‘0’, `trackbacks` int(11) NOT NULL default ‘0’, `last_modified` datetime NOT NULL default ‘0000- 00-00 00:00:00’, KEY `post_id` (`post_id`) ) TYPE=MyISAM; * — — Dumping data for table `wp_ak_popularity` — * I deleted: SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; ENGINE=MyISAM DEFAULT CHARSET =latin1; * and it uploaded all my files. * NOW,lol, I don’t however have any access to the administrative dashboard! I so wish I knew what I was doing here! Ive been through most of the files and cant find out why this didn’t create the admin dashboard access?! any suggestions? * Thread Starter [manfredeye](https://wordpress.org/support/users/manfredeye/) * (@manfredeye) * [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-607171) * Only because I have spent many many hours and days looking for answers for my issues and came across many unfinished questions I want to finish this error just in case it may help someone else. with that said: * My problem lied with not using a fresh WP download. I deleted all my wordpress installation by using my ftp server. Downloaded a fresh wordpress installation. uploaded that to my ftp server. then activated it without issue. After the fresh install I THEN imported all my plug ins and any other extra perks. I believe that was what was holding me back along with also misinformation that was nestled in my old version from my last webhost. So now all is working and all I need do is get rid of the funky characters that are still lurking that weren’t there before. I guess its all about carrying around old baggage!..hehe Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘database error –’ is closed to new replies. ## Tags * [blog transfer](https://wordpress.org/support/topic-tag/blog-transfer/) * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * [lost information](https://wordpress.org/support/topic-tag/lost-information/) * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 9 replies * 2 participants * Last reply from: [manfredeye](https://wordpress.org/support/users/manfredeye/) * Last activity: [18 years, 9 months ago](https://wordpress.org/support/topic/database-error-6/#post-607171) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics