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. 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. 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. 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 Link to comment https://forums.phpfreaks.com/topic/210681-mysql-backuprestore/#findComment-1099833 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.