2/2/2024 0 Comments Download phpmyadmin mysqldump![]() ![]() replace $config->user with the actual user, etc…). It will not work out of the box on Joomla 1.0, but it will work if you hardcode the database information in the script (e.g. The script will work on Joomla versions 1.5.x, 1.6.x, 1.7.x, 2.5.x, and 3.2.x (3.5 is not yet released at the time of publishing this article). For very larges sites, it might take an hour or more (note that you will need to modify max_execution_time in the script to a higher value if your database is quite large). For small websites, it can take less than a second to finish. That depends on the size of your database and your server’s horsepower. ![]() Yes – it is very reliable and you will be able to replicate your current database based on this export. ![]() Contact us if you’re using another RDBMS (such as Oracle, MySQL, or PostgreSQL) and we’ll create the export script for you. Other RDBMS’s have similar tools, although not as easy to use. It’ll only work on MySQL (which is the database powering over 90% of Joomla websites anyway), this is because it uses the MySQL tool called mysqldump. ![]() If your configuration.php file is stored elsewhere, then you will need to hardcode the database settings into the script. Note that the dbdump.php file must be under the root directory of your website and must be at the same level of the configuration.php file. Once you do that, just point your browser to and you’ll be presented with a link to download the database backup (please note that it might take some time for the link to appear). User.' -password='.$config->password.' -host='.$config->host.' '.$config->db.' > '.$_SERVER.'/'.$dbFile) Īll you need to do is to place the above code in a file called dbdump.php and put that file under the root directory of your Joomla site. Since we, at itoctopus, want to make the life of every Joomla website administrator easier, we are releasing the code for doing this, for free, for anyone to use! The code is below: We get occasional requests from customers who don’t have access to a phpMyAdmin instance asking us to backup their whole database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |