Blog Posts on sql yog




Percent:
 
Distinct:
 


Bak-up in SQLYog for MYSQL by Alex Fernandez on May 23, 2009First run SQLYog.Then Enter the necessary information including connection name, username, password then click connect.On the DB menu select Back-up Database as SQL DUmp or CTRL+ALT+E and a SQL DUMP dialog box will appear. Here Selec...



Using SQL Yog for MYSQL by Alex Fernandez on May 21, 20091. First Download a copy of SQL Yog. Note that you must download the sqlyog commnunity Edition. But if you are wealthy you can buy the enterprise edition of SQLYog You can download a copy of SQLYOG in in this URL: http://www.weby...



Creating a Back-up in MYSQL in Windows by Alex Fernandez on May 20, 2009go to command prompt Type In mysqldump -u (username) -p(password) (database name) > (The Directory and FileName.sql) Example: mysqldump -u root -p1 coop > C:/backup.sql...



Access MYSQL in Command Prompt by Alex Fernandez on May 20, 20091. Go to Command Prompt2. Type mysql -u (Username for MYSQL) -p(then you are prompted to enter the required password and key in ENTER) (if your password is accepted, you will see a welcome message from MYSQL else the command prompt will close im...



Restore a Back-Up in MYSQL by Alex Fernandez on May 20, 2009goto command prompt Type in:mysqldump -u (username) -p(password) (database name) < (The Directory and FileName.sql) Example: mysqldump -u root -p1 coop < C:/backup.sql...