Missing column in PHPMyAdmin export


Collins

I exported a table from the server that 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 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 columns and I get an error when trying to import...

#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

Should I be setting something here? I've installed WAMP a few times and the default SQL export has been fine. The database is exactly the same, the database on WAMP just ignores the load of columns and data when exporting. I definitely selected all table structures and data for export.

Collins

God knows why, but Phpmyadmin's export is messed up.

I SSH into msql5.7.11/bin and use the mysqldump --databases test > dump.sqlalternative

Related


Missing column in PHPMyAdmin export

Collins I exported a table from the server that 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 tha

Missing foreign key constraint after phpmyadmin export

GVillani82 I use the following script to create table in mysql: CREATE TABLE IF NOT EXISTS users_x_activities( id int NOT NULL auto_increment, id_user int unsigned NOT NULL, id_attivita int unsigned NOT NULL, PRIMARY KEY (id), FOREIGN KEY (id_user

Missing foreign key constraint after phpmyadmin export

GVillani82 I use the following script to create table in mysql: CREATE TABLE IF NOT EXISTS users_x_activities( id int NOT NULL auto_increment, id_user int unsigned NOT NULL, id_attivita int unsigned NOT NULL, PRIMARY KEY (id), FOREIGN KEY (id_user

How to export table to CSV with column names in PHPMYADMIN

Rajan I'm trying to export the users table to CSV using PHPMYADMIN, but I only get the records, not the column names. So how to do it? I'm trying to import a CSV, but it requires column names, so I want to use a CSV with column names! Mansouri where you downlo

How to export table to CSV with column names in PHPMYADMIN

Rajan I'm trying to export the users table to CSV using PHPMYADMIN, but I only get the records, not the column names. So how to do it? I'm trying to import a CSV, but it requires column names, so I want to use a CSV with column names! Mansouri where you downlo

How to export table to CSV with column names in PHPMYADMIN

Rajan I'm trying to export the users table to CSV using PHPMYADMIN, but I only get the records, not the column names. So how to do it? I'm trying to import a CSV, but it requires column names, so I want to use a CSV with column names! Mansouri where you downlo

Import and export databases, phpmyadmin

gabriele.pacor How to import and export database in phpmyadmin? I can find the database on my home computer, but I want to use my database on my school computer. So what do I want to do? Edward 99 Go to the database, click to export, choose the format (if only

Import and export databases, phpmyadmin

gabriele.pacor How to import and export database in phpmyadmin? I can find the database on my home computer, but I want to use my database on my school computer. So what do I want to do? Edward 99 Go to the database, click to export, choose the format (if only

phpmyadmin: missing json extension

you're someone who doesn't use Git what did I do I have setup a LAMP web server with the following command: sudo apt-get install apache2 sudo apt-get install mysql-server sudo apt-get install php5 libapache2-mod-php5 sudo /etc/init.d/apache2 restart Then I in

phpMyAdmin not working missing functionality

Hunsu I have phpmyadmin installed but when I try to start it it doesn't. I have this error: Fatal error: Call to undefined function PMA_DBI_num_rows() in /usr/share/phpmyadmin/libraries/navigation/Nodes/Node.class.php on line 397 I have installed php5-mysql a

phpmyadmin: missing json extension

you're someone who doesn't use Git what did I do I have setup a LAMP web server with the following command: sudo apt-get install apache2 sudo apt-get install mysql-server sudo apt-get install php5 libapache2-mod-php5 sudo /etc/init.d/apache2 restart Then I in

500 error on phpmyadmin export at /phpmyadmin/export.php

Sunbathing I'm getting HTTP error 500 when trying to export from phpmyadmin. This only happens after clicking the "Export" button after setting all export settings. I am able to execute mysqlbackup just fine, but I am getting an error on export.php. I'm not qu

500 error on phpmyadmin export at /phpmyadmin/export.php

Sunbathing I'm getting HTTP error 500 when trying to export from phpmyadmin. This only happens after clicking the "Export" button after setting all export settings. I am able to execute mysqlbackup just fine, but I am getting an error on export.php. I'm not qu

500 error on phpmyadmin export at /phpmyadmin/export.php

Sunbathing I'm getting HTTP error 500 when trying to export from phpmyadmin. This only happens after clicking the "Export" button after setting all export settings. I am able to execute mysqlbackup just fine, but I am getting an error on export.php. I'm not qu

500 error on phpmyadmin export at /phpmyadmin/export.php

Sunbathing I'm getting HTTP error 500 when trying to export from phpmyadmin. This only happens after clicking the "Export" button after setting all export settings. I am able to execute mysqlbackup just fine, but I am getting an error on export.php. I'm not qu

500 error on phpmyadmin export at /phpmyadmin/export.php

Sunbathing I'm getting HTTP error 500 when trying to export from phpmyadmin. This only happens after clicking the "Export" button after setting all export settings. I am able to execute mysqlbackup just fine, but I am getting an error on export.php. I'm not qu

Export database fails in phpmyadmin (localhost)

Furkan Gocurucu When I try to export the database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete due to short execution time at the PHP level". I do not know what to do.. shafizadi I've had the exact problem. Based on th

Export from phpMyAdmin minus username?

posfan12 Is there a way to export the database to text in phpMyAdmin without the and other clauses DEFINERshowing my admin username and IP ? thanks. Tyrone I looked at the source code of phpMyAdmin - it turns out that it just gets the output of the SHOW CREATE

Export database fails in phpmyadmin (localhost)

弗坎・古库鲁库(Furkan Gocurucu) When I try to export the database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete due to short execution time at the PHP level". I do not know what to do.. Shafizadeh I've had the exact problem. B

Export database fails in phpmyadmin (localhost)

Furkan Gocurucu When I try to export the database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete due to short execution time at the PHP level". I do not know what to do.. shafizadi I've had the exact problem. Based on th

Export database fails in phpmyadmin (localhost)

Furkan Gocurucu When I try to export the database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete due to short execution time at the PHP level". I do not know what to do.. shafizadi I've had the exact problem. Based on th

Export database fails in phpmyadmin (localhost)

Furkan Gocurucu When I try to export the database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete due to short execution time at the PHP level". I do not know what to do.. shafizadi I've had the exact problem. Based on th

Export table without phpMyAdmin in MAMP

bite I've been working on a web application using ExtJS and hosting a SQL database on phpMyAdmin using MAMP. About 2 weeks ago I had to throw away my old HD due to bad sectors and got an SSD as a replacement. After installing the application again (IDE, docume

phpmyadmin CSV file import and export

Kobus Myburgh When I try to import a CSV file in phpmyadmin, I get a green message with "0 rows", but it's still a success message. I know my data is correct because it imports fine on another computer. Also, when exporting, I have to export in "view as text"

Export large database mysql phpmyadmin

ahajib I am using phpmyadmin on Windows OS. I have a database with a table with 100M records and a size of 20GB. I want to export this table and have table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache e

Export large database mysql phpmyadmin

ahajib I am using phpmyadmin on Windows OS. I have a database with one table with 100M records and a size of 20GB. I want to export this table and have table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache

Mysql phpmyadmin export/import columns

Ivan I followed this guide to export columns http://stackoverflow.com/questions/4486743/how-do-i-export-particular-column-in-mysql-using-phpmyadmin My SQL table is: id, name, description, url, label, category_id ................. So I want to export the colum