Backing up and Restoring mysql database could be done through several ways. You can backup and restore by exporting SQL script using MySQL command line or copying MySQL data directory from the original server to the destination server.
Using the second method will cause the stored procedure and function missing. In this article we will discuss how to overcome the situation.
phpMyBackupPro is a tool created using PHP programming language that can be used to perform backup and restore on MySQL database server. In this article we are going to learn how to install and configure this tool, perform manual backup and then perform restore the previously backed up database. We will also learn how to setup an automatic periodic backup using the same tool.
Installation of this tool is simple. Just download the newest version from http://www.phpmybackuppro.net/download.php.
After downloading, extract the zip file to a directory on your PHP and Apache web server accessible from browser, ie the Document Root, for example C:\XAMPP\HTDOCS. Then you will get a new folder under it, for example C:\XAMPP\HTDOCS\phpMyBackupPro.
That’s it! Now go to your web browser and point the URL of phpMyBackupPro, for example http://localhost/phpMyBackupPro.
Anda mempunyai database PostgreSQL yang sudah berjalan di Windows kemudian ingin direstore ke server PostgreSQL yang berjalan di Linux.
Recent Comments