Xampp 7.2.4 (Linux) PhpMyAdmin Export Problem
Posted: 05. May 2018 18:55Hi, I'm using Xampp 7.2.4 on Linux. I'm having trouble exporting a database with phpmyadmin. Phpmyadmin's own demo page does not have this problem. I also tested this problem in Windows version of Xampp 7.2.4. I write down the details of the problem below. You can try.
== My sample table ==
CREATE TABLE `posts` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
After creating the table, I export it via phpMyAdmin.
== PhpMyAdmin Exported ==
CREATE TABLE `posts` (
`id` int(10)
) ;
Problem: If the id column in the posts table is not unsigned then it is exporting properly. As the column is unsigned, export is running corrupt. As I mentioned above, there is no problem with the same version of Windows. The problem exists only in the Linux version. I also experimented with the same version of phpMyAdmin's MariAdB test server, and it makes the exports work properly. The problem is entirely related to Linux xampp.
What can we do about it? I need to fix this problem because I export a lot of files with phpmyadmin. Thank you.
== My sample table ==
CREATE TABLE `posts` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
After creating the table, I export it via phpMyAdmin.
== PhpMyAdmin Exported ==
CREATE TABLE `posts` (
`id` int(10)
) ;
Problem: If the id column in the posts table is not unsigned then it is exporting properly. As the column is unsigned, export is running corrupt. As I mentioned above, there is no problem with the same version of Windows. The problem exists only in the Linux version. I also experimented with the same version of phpMyAdmin's MariAdB test server, and it makes the exports work properly. The problem is entirely related to Linux xampp.
What can we do about it? I need to fix this problem because I export a lot of files with phpmyadmin. Thank you.
