Search the Community
Showing results for tags 'phpmyadmin'.
Found 2 results
I've never encountered this issue before. My local installing is using AMPPS 3.7, setup about 3 months ago. Everything was working fine last night, and I think possibly this morning, before it complete stopped with these errors. Please see below. I have not changed any config setttings, access settings. The only 2 other things I did yesterday was log into phpmyadmin and export the DB, then I think an Xcode update was installed yesterday. Can anyone help? I know people have run into these issues when they migrate, but I haven't migrated, setup, changed anything. Some people have said to just disable to do something like: $cfg['Servers'][$i]['AllowNoPassword'] = true; In phpMyAdmin's config.inc.php file. I tried but that didn't work. I even tried changing: $config->dbHost = 'localhost'; to 127.0.0.1, in site/config.php but no good.
phpMyAdmin export -> import errorsHi all I have big troubles with my DB backups and phpMyAdmin. I can't manage to import a backup. The phpMyAdmin export settings are left to the defaults. The error message I get: #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 'INSERT INTO `caches` (`name`, `data`, `expires`) VALUES ('ModulesUninstalled.in' at line 11 When I delete the complete 'cache' section there are almost for all tables the same errors. (part of the dump attached) I had this problem before and back then (couple months ago) I think I copied almost every table individually. I thought it was specific to that DB. But I can't do a dump/import of any of my PW installations. MySQL: 5.6.27 PHP version: 7.0.11 phpMyAdmin: 184.108.40.206 Anybody knows that problem? Or what to do? phpMyAdmin SQL Dump.sql