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. Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/ 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. Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275661 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. Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275675 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 Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275690 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. Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275692 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 Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275694 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. Link to comment https://forums.phpfreaks.com/topic/55805-solved-upload-database/#findComment-275695 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.