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. Quote Link to comment 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" Quote Link to comment 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. Quote Link to comment 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 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 Quote Link to comment 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..?? Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted October 8, 2007 Share Posted October 8, 2007 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 Quote Link to comment Share on other sites More sharing options...
shamsuljewel Posted October 8, 2007 Author Share Posted October 8, 2007 My phpmyadmin shows this error 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.