Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHPMyAdmin Missing Columns in Export

Tags:

phpmyadmin

I export a table from my server, and it looks like this...

CREATE TABLE IF NOT EXISTS `actions` (
  `aid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique actions ID.',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The object that that action acts on (node, user, comment, system or custom types.)',
  `callback` varchar(255) NOT NULL DEFAULT '' COMMENT 'The callback function that executes when the action runs.',
  `parameters` longblob NOT NULL COMMENT 'Parameters to be passed to the callback function.',
  `label` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Label of the action.',
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores action information.';

However, I have just reinstalled WAMP, and when I export from there, it looks like this....

CREATE TABLE IF NOT EXISTS `actions` (
  `aid` varchar(255) NOT NULL DEFAULT '0'COMMENT
) ;

This is missing all of the columns, and when trying to import, has the error...

#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 ')' at line 3

Is there anything I should be setting here? Ive installed WAMP a few times before, and the default SQL export has always been fine. The databases are exactly the same, the one on WAMP just ignores loads of columns and data when exporting. I have definitely selected all table structure and data for export.

like image 952
Collins Avatar asked Apr 06 '26 18:04

Collins


1 Answers

God knows why but the export in Phpmyadmin is messed up.

I ssh'd to msql5.7.11/bin and used mysqldump --databases test > dump.sql instead

like image 110
Collins Avatar answered Apr 08 '26 15:04

Collins



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!