mubarakabbas Posted January 2, 2010 Share Posted January 2, 2010 Hi Guys, I am building a CMS, where in my Admin module, I want o export all my tables/Database and save it in my local folder in my PC. How to do it, is there any ready code, or give a hint of it.. thank you Link to comment https://forums.phpfreaks.com/topic/186954-how-to-export-a-tables/ Share on other sites More sharing options...
teamatomic Posted January 3, 2010 Share Posted January 3, 2010 SELECT * INTO OUTFILE '$bak' FROM $table HTH Teamatomic Link to comment https://forums.phpfreaks.com/topic/186954-how-to-export-a-tables/#findComment-987405 Share on other sites More sharing options...
laffin Posted January 3, 2010 Share Posted January 3, 2010 Easiest way, is use a gui interface (phpmyadmin/mysqlcc/mysql workbench). I prefer mysqlcc (but if used on remote server, you have to give your ip access to the db). Most will export the database schema as well as the entries Link to comment https://forums.phpfreaks.com/topic/186954-how-to-export-a-tables/#findComment-987419 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.