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