shamsuljewel Posted October 8, 2007 Share Posted October 8, 2007 Hello guys, I am using phpmyadmin to export and import mysql databases. But Now my database size is 3.4 MB so I can export the database using phpmyadmin but I can't import it because phpmyadmin support upto 2.8 MB file size. So what should I do now...!!??? Please give me suggestion...urgent. Thanks. Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/ Share on other sites More sharing options...
~n[EO]n~ Posted October 8, 2007 Share Posted October 8, 2007 You can compress it and export, phpMyAdmin supports compression method Save as file File name template (1): ( remember template ) Compression: None "zipped" "gzipped" Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364423 Share on other sites More sharing options...
shamsuljewel Posted October 8, 2007 Author Share Posted October 8, 2007 yeah This option has in my local phpmyadmin. But in webserver phpmyadmin haven't this option only none selected. So I need annother way to export and import mysql database. Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364425 Share on other sites More sharing options...
~n[EO]n~ Posted October 8, 2007 Share Posted October 8, 2007 Local or server phpMyAdmin is all the same.... I don't think that it does not support importing compressed method. BTW, which version phpMyadmin u have online... I got 2.9.1.1 but it supports importing compressed file... You can export first Table structures and later INSERT values (i mean part by part) Edit : I just saw my phpMyAdmin, it is written Quote Location of the text file (Max: 4,096KiB) Character set of the file: Imported file compression will be automatically detected from: None, gzip, bzip2, zip Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364429 Share on other sites More sharing options...
shamsuljewel Posted October 8, 2007 Author Share Posted October 8, 2007 Yeah I can export tables indivisualy..but its boooooring. I also use 2.9.1.1 but I dont know why in my server there was no .zip option but in local machine I have that.. May be the webserver is configured as like this. But may be there have another way to export and import databases like by using cmp promp on mysql..?? Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364435 Share on other sites More sharing options...
~n[EO]n~ Posted October 8, 2007 Share Posted October 8, 2007 Quote I also use 2.9.1.1 but I dont know why in my server there was no .zip option but in local machine I have that.. May be the webserver is configured as like this. Why don't you try importing compressed file online, it does not ask you "Which file you are uploading", just give a try. It is written Imported file compression will be [b]automatically[/b]detected from: None, gzip, bzip2, zip Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364437 Share on other sites More sharing options...
shamsuljewel Posted October 8, 2007 Author Share Posted October 8, 2007 My phpmyadmin shows this error Quote Error No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16. Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364440 Share on other sites More sharing options...
shamsuljewel Posted October 8, 2007 Author Share Posted October 8, 2007 I create a zip file and then import the .sql file and it works. Link to comment https://forums.phpfreaks.com/topic/72268-solved-export-and-import-mysql-database/#findComment-364447 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.