QuePID Posted August 13, 2010 Share Posted August 13, 2010 I used phpmyadmin version 3.3.3 to back up MySQL table data and would love to know how to restore the data to mysql via PHP (not phpmyadmin). Also how can one produce phpmyadmin compatible .sql dumps of a tables data? I know easy ways of doing this via the mysql command console, but want to be able to handle this via php. Quote Link to comment https://forums.phpfreaks.com/topic/210681-mysql-backuprestore/ Share on other sites More sharing options...
otuatail Posted August 14, 2010 Share Posted August 14, 2010 I am having the same problem and have posted a problem. Within myadmin there is an export statment that allows a text based query that can be restored. The problem with that is if you have vast amounts of data. If you don't it might work. In my case it could be very hard. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/210681-mysql-backuprestore/#findComment-1099184 Share on other sites More sharing options...
fenway Posted August 14, 2010 Share Posted August 14, 2010 Sorry, I don't follow -- if you have SQL statements, just issue them one a at a time. Quote Link to comment https://forums.phpfreaks.com/topic/210681-mysql-backuprestore/#findComment-1099303 Share on other sites More sharing options...
jdavidbakr Posted August 16, 2010 Share Posted August 16, 2010 If you've got command line access, that's the easiest way to load a huge db from a mysqldump - mysql the_database < cat backup.sql Quote Link to comment https://forums.phpfreaks.com/topic/210681-mysql-backuprestore/#findComment-1099833 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.