sirfsaif Posted December 24, 2008 Share Posted December 24, 2008 I am currently using MySQL 4.0 and my requirement is to archive existing historical data which may require to extract in future (once in a month). Please let me know how can we do this. Thanks in anticipation. Link to comment https://forums.phpfreaks.com/topic/138290-how-to-archive-data-in-mysql-4/ Share on other sites More sharing options...
Mchl Posted December 24, 2008 Share Posted December 24, 2008 mysqldump is a small utility application shipped with every MySQL distribution. It's supposed to do just this. Dump all (or selected) tables into a txt file. Link to comment https://forums.phpfreaks.com/topic/138290-how-to-archive-data-in-mysql-4/#findComment-723123 Share on other sites More sharing options...
Maq Posted December 24, 2008 Share Posted December 24, 2008 You can dump your DB in a .sql file using: -h[host] -u"username" -p"password" "dbname" > /[dir]/file_name.sql Link to comment https://forums.phpfreaks.com/topic/138290-how-to-archive-data-in-mysql-4/#findComment-723178 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.