madhukar_garg Posted May 25, 2007 Share Posted May 25, 2007 Dear all, I have developed a site on localhost. now i want to upload it on webserver. the main problem is that server has phpmyadmin 2.5.2-pl1. can anyone tell me how to upload data using phpmyadmin 2.5.2. i have already export the database and trying to import the txt file generated by my localhost myadmin but it is not working.... is there any priviliges problem with it.. please help me......... thanks Madhukar garg Quote Link to comment https://forums.phpfreaks.com/topic/52925-problem-with-database-uploadingpls-help/ Share on other sites More sharing options...
jitesh Posted May 25, 2007 Share Posted May 25, 2007 Remove this line from create table query and try "ENGINE=InnoDB DEFAULT CHARSET=latin1" OR "ENGINE=MyIsm DEFAULT CHARSET=latin1" Quote Link to comment https://forums.phpfreaks.com/topic/52925-problem-with-database-uploadingpls-help/#findComment-261349 Share on other sites More sharing options...
madhukar_garg Posted May 25, 2007 Author Share Posted May 25, 2007 Hi jitesh, Thanks for reply but my database has about 40 tables and it is not possible to remove line one by one to each table.... do you have any other solution please thanks Madhukar garg Quote Link to comment https://forums.phpfreaks.com/topic/52925-problem-with-database-uploadingpls-help/#findComment-261354 Share on other sites More sharing options...
jitesh Posted May 25, 2007 Share Posted May 25, 2007 you can use replace all function from any editor (software). Quote Link to comment https://forums.phpfreaks.com/topic/52925-problem-with-database-uploadingpls-help/#findComment-261356 Share on other sites More sharing options...
madhukar_garg Posted May 25, 2007 Author Share Posted May 25, 2007 hi, my host server has old versions of php, mysql and phpmyadmin but on local server i have latest versions of php(5.2.0), mysql(5.0.27) and phpmyadmin(2.9.1.1). is this thing creates problem for me in uploading database......? pls help me thanks madhukar garg Quote Link to comment https://forums.phpfreaks.com/topic/52925-problem-with-database-uploadingpls-help/#findComment-261507 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.