mmarif4u Posted June 16, 2007 Share Posted June 16, 2007 How can i upload a bigger size mysql database to server. Plz its urgent. Size is around 50mb. Quote Link to comment Share on other sites More sharing options...
Psycho Posted June 16, 2007 Share Posted June 16, 2007 FTP? But really, you need to be more specific. What format is this database in? Is this an export from a database in a *.sql file or something similar? I'm assuming your issue is that you cannot upload that big of a file through PHPMyAdmin. Is the data written in transactional records? If so, you could upload the file to your web space and then use a PHP script to process the file. Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted June 16, 2007 Author Share Posted June 16, 2007 Yes u right, I am thinking of a script to upload it. The file is .gz format. I lready upload it to ftp, now how can restore it. Quote Link to comment Share on other sites More sharing options...
PC Nerd Posted June 16, 2007 Share Posted June 16, 2007 ok.......um. not too familiar with .gz, but itns tit compression like .zip? what id do is get your current database, and export the entire thing usung phpmyadmin.... then table by table, or record group by record group, runt eh create of inster queries throught eh new phpmyadmin database...... gdlk Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted June 16, 2007 Author Share Posted June 16, 2007 Running mysql queries its not possible for me bcoz i have alot of data, For example in one table i have 70,000 records and i have 72 tables. Quote Link to comment Share on other sites More sharing options...
PC Nerd Posted June 16, 2007 Share Posted June 16, 2007 well, what format is the actual database is.... .txt, .sql etc? youll need to "unzip" the .gz to find out...... try 7-zip file manager to do so..... and let us know whats in the .gz. thanks Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted June 16, 2007 Author Share Posted June 16, 2007 format is .sql , i know all these things how to unzip and zip but the prob is to restore. So now i start it manully to restore. 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.