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. Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.