Showing posts with label My Tutorials | MySQL. Show all posts
Showing posts with label My Tutorials | MySQL. Show all posts

Connect to remote MySQL database using SQLyog instead of PHPMyAdmin through cpanel | MySQL GUI Tools

Hello everyone. Today we are going to go through a mysql tutorial on remote database administration. We all know that we can manage mysql database using PHPMyAdmin through cPanel in our web host panel. But sometimes we may not have access to cPanel, but FTP and MySQL login details. So how do you connect at that time without login to cPanel?

How to backup all databases at once in localhost windows WAMP server

Hello everyone, today with another short tutorial on MySQL and my ultimate MySQL GUI interface of choice, SQLYog. Sometimes, like after a clean windows install or HDD issue or virus/malware attack etc. we need to reinstall our WAMP server. In general our MySQL server also get reinstalled with WAMP and we lose all our databases ! Scary right? Again exporting each and every databases one by one is tedious task for me as my root user on localhost accesses nearly 87 databases. So is there any solution? Obviously yes, if you have got your copy of SQLYog. You can backup all your databases on localhost at once as separate *.sql files or in one file at zip also.