Comments for How to Export Your Joomla! Database with phpMyAdmin at http://www.howtojoomla.net , comment 1 to 23 out of 20 comments http://www.howtojoomla.net Thu, 18 Mar 2010 05:05:37 +0100 FeedCreator 1.7.3 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1799 I have access by ftp and I wonder how to export all database to a sql or csv file - avanzaweb Mon, 05 Oct 2009 04:46:17 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1766 thanks so much - ندى الورد Mon, 21 Sep 2009 23:31:14 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1765 Also if you already have same tables in the destination joomla database it is important to check "add drop table" and add if not exist" And also select export type insert, update or replace accordingly. Always backup your orginal database before importing anything! - مركز تحميل Mon, 21 Sep 2009 23:30:49 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1764 I've tried changing bluetooth stacks, adapters, and reverting to the earlier version, as suggested in the post. - منتديات Mon, 21 Sep 2009 23:30:15 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1686 Hi, For any reason, I don't see pictures on this very interesting website. Please, advise what to do. I am using IE7. Regards, Dusan - dusan kolar Mon, 31 Aug 2009 01:54:25 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1654 This tutorial isn't displaying the screen shots, so please post the information that is needed on step: "phpMyAdmin Export Screen." I'm crossing my fingers at this point. thanks in adv. :) - Robert Kash Jr Wed, 05 Aug 2009 17:28:09 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1433 I have a script to backup and restore any database - takes seconds to run. - منتديات Sun, 05 Apr 2009 08:17:11 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1425 How do you export it, so that when you import it into the new database that it "amends" and doesn't overwrite what is already there? - okinawa Wed, 01 Apr 2009 00:59:11 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1164 Great tutorial! Love this one! Exporting is so important - Joomla Webdesign Mon, 24 Nov 2008 09:55:24 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-1030 Thx for the tutorial helped me out just fine ! - webdesign Wed, 08 Oct 2008 03:14:46 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-891 Hello evry one looking for export to make my site videobabylon.ca frindly with google and also same more thinks done on the website. contact me - rafi michael Thu, 03 Jul 2008 22:59:27 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-870 I finally put up a great backup script to manage any and multiple MySQL databases. www.MySQLBackup.info Next step is that I need to see if it can be made into a Joomla plugin. - Vince Sat, 28 Jun 2008 02:51:43 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-824 is it ajax based comment box ? - mark Sat, 07 Jun 2008 21:01:03 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-724 I just stumbled on your site. From my experience I have not had issues with moving database with phpmyadmin. Actually I like it a lot. But thats me. With regards to your artcle you said [quote]Leave your SQL options like they are (unless they are different from what you see in the picture).[/quote] I think its a good idea to check if you are running the same version of mysql or both servers. If not, you migh need to need to select the export compatibilty to the version of mysql you want to export to. Also if you already have same tables in the destination joomla database it is important to check "add drop table" and add if not exist" And also select export type insert, update or replace accordingly. Always backup your orginal database before importing anything! Long live Joomla! - Gabriel Mon, 10 Mar 2008 06:16:54 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-658 Great! ;D - Masi Tue, 25 Dec 2007 04:14:16 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-561 I have a script to backup and restore any database - takes seconds to run. I'll try and make it a Joomla add-on soon. :) :) :) - Vince Thu, 25 Oct 2007 05:56:51 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-378 Oops, I mean read, not write :o - Hasanul Sat, 23 Jun 2007 07:46:33 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-377 I late write this great article. Just make a fresh install in new host. Just wondering, how to export just content database to my new database? Thanks before ;D - Hasanul Sat, 23 Jun 2007 07:45:54 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-237 Hi Nick, That's a great question. To be honest, I do not know the answer to that. I assume that the writer of that article knew what he was talking about, so I have no reason to disagree with that view. I personally have never experienced a problem exporting a database with phpMyAdmin for Joomla! 1.0.x, but I've never tried it with Joomla! 1.5. The best advice I can give when working directly with your database is to take every possible precaution. If you are uncertain about the possible ramifications, I recommend hiring a professional to do it for you. Cory - Cory Sat, 17 Mar 2007 21:57:11 +0100 http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin#comment-236 Hi Cory, Great articles, I've read many of them and they have really helped my understanding of Joomla. Following one of your links re Joomla 1.5 and hence to backward compatibility, I came across [quote]First a word of warning! The popular tool, ‘phpMyAdmin’ performs unrequested and usually incorrect encoding conversions during export of site data. There is currently no way to control this. For this reason it is NOT recommended to use phpMyAdmin for migration. [/quote] at [url]http://dev.joomla.org/component/option,com_jd-wp/Itemid,33/p,107/[/url] Do you agree with this view? - Nick Sat, 17 Mar 2007 21:00:07 +0100