random1 Posted June 20, 2008 Share Posted June 20, 2008 How do you use PHP to backup a mySQL (InnoDB) database? Link to comment https://forums.phpfreaks.com/topic/111049-how-to-use-php-to-backup-a-mysql-innodb-database/ Share on other sites More sharing options...
cooldude832 Posted June 20, 2008 Share Posted June 20, 2008 depends what you want to backup? phpymadmin has very nice backing up software if you want to write your own you need to 1) Get the tables you want to back up 2) Get their content 3) Store it start there and ask questions on what u can't do in 1,2,3 Link to comment https://forums.phpfreaks.com/topic/111049-how-to-use-php-to-backup-a-mysql-innodb-database/#findComment-569856 Share on other sites More sharing options...
abdfahim Posted June 20, 2008 Share Posted June 20, 2008 well once I have such kind of difficulty because its tough to get backup using phpmyadmin if the table is very very large, like my case, the table has more than 1 million records with more than 100 columns. There is a process call mysqldump, you can find plenty of result if you search, but for some reason I cant totally successfull using that command. MyISAM db has a very neat and easy way to backup the data, you have to only backup the mysql/data folder from your harddisk. Link to comment https://forums.phpfreaks.com/topic/111049-how-to-use-php-to-backup-a-mysql-innodb-database/#findComment-569898 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.