Backup & Restore Database as SQL Dump by SqlYog

Direct Connection using MySQL C API (Sqlyog)

→ Download SQLyog Community Edition from this url and install /run https://github.com/webyog/sqlyog-community/wiki/Downloads
fter you have connected to an instance of MySQL, you can make additional connections by selecting the New Connection option from the File menu.

Saved Connections
Select the connection name from the list. To rename a saved connection, click on the Rename button and edit the connection name and click save option to save the changed connection name. Other details can also be changed by selecting the particular connection, changing the necessary values and then by clicking on save to save those values.
MySQL Host Address
Specify a host name where the database is situated or the IP address of the server.
User Name
Specify a user name for connecting to the database server.
Note: This is MySQL username. Not your FTP or web server username.
Password
Type MySQL user Password
Save Password
Check this option if you want SQLyog to save your MySQL password and to stop asking you to enter it in the future.
Port
Define a TCP/IP port for connecting to the database server.
Databases
Database name. You may enter several database names separated by semicolon (like db1;db2). If you do not enter the database name, all the database names would be listed, to select from.

Backup Database as SQL Dump by SqlYog





→ Right click on Database which you want backup then click Backup/Export -> Backup Database As Sql Dump
→ In New opened window, select below option as per screen above shot.

  1. Select Structure & Data
  2. Select Export to file location and then give backup “filename.sql”
  3. Select Option Set FOREIGN_KEy_CHECKS=0 & Include “DROP” statment(s)
  4. Then Export.


Restore Database from SQL Dump By SqlYog

→ Right click on Database which you want to restore, then click Import < Restore From Sql Dump as per above image.




→ Then select sql Sump file where you stored .

→ Click Execute .



Comments

Post a Comment

Popular posts from this blog

Postfix can support per-domain outgoing IP addresses, but is not currently configured to do so

Sender Dependent Outgoing IP Address (Virtualmin) Introduction to Outgoing IPs By default, when your mail server sends out email the SMTP connection will come from the system's default IP address, typically that assigned to. eth0 Even if the email is from a domain that has its own private IP, that address will not be used when sending an email. This behavior can be changed on systems running Postfix version 2.7 and Virtualmin 3.94 or later so that outgoing email from a domain with a private IP address appears to come from that address. This can be useful for separating email from multiple domains as seen by other mail servers, or for setting up per-domain reverse DNS records. Initial Configuration This feature requires Postfix 2.7 (seen on most modern Linux distributions), Virtualmin 3.93 and ideally Webmin 1.600. The steps to set it up are as follows: SSH into the system as, root and edit the  /etc/postfix/main.cf  file. Look for a line starting with. sender_depe
Read more

How to download Virtual machine image of google cloud to local computer

======================================================================== Command to download Virtual machine image of google cloud to local computer. ======================================================================== 1.Download GoogleCloudSDKInstaller.exe and install in windows computer. 2.Configured Gcloud credential and region. 3.If you don't have any bucket then create one bucket to  store exported image. 4.Run below command in gcloud cli: gcloud compute images export --destination-uri gs://my-bucket/my-image.tar.gz \ --image my-image --project my-project or gcloud compute images export --destination-uri gs://my-bucket/my-image.tar.gz --image my-image --project_ My First Project 5. After finish, you can download the exported image of the virtual machine from gcloud bucket. ========================================================================
Read more