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

Wanna-cry-ransomware

Do those following things in the windows system. 1.  Block port 138.139,445 with the firewall. 2. How to enable or disable SMB protocols on the SMB server:     Windows 7, Windows Server 2008 R2, Windows Vista, and Windows Server 2008       To enable or disable SMB protocols on an SMB Server that is running Windows 7, Windows Server 2008 R2, Windows Vista, or Windows Server 2008, use Windows PowerShell or Registry Editor.      Windows PowerShell 2.0 or a later version of PowerShell     To disable SMBv1 on the SMB server, run the following cmdlet:         Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters" SMB1 -Type DWORD -Value 0 -Force     To enable SMBv1 on the SMB server, run the following cmdlet:         Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters" SMB1 -Type DWORD -Value 1 -Force -: Windows Vista, Windows Server 2008, Windows 7, Windows Server 2008 R2, Windows 8,
Read more