'Mysql' Category

  • Restoring corrupt MySQL tables

    November 26, 2009

    While working with MySQL tables you may notice it sometime corrupting themselves periodically. However MySQL offers a easy and speedy method of repairing those tables.
    Here are few steps that can help you to repair the corrupt MySQL tables;
    Login to your VDS via SSH and change directories to the database that is having problems.
    cd /usr/local/mysql/var/[DBNAME]/
    You will [...]

  • Mysql Options Database

    September 17, 2009

    Mysql Program support the following switches that you can use likewise the short single character or more verbose versions. Check it below;
    -\?, –help      Print usage information.
    -d, –debug=[options]     Output debug information to log. Generally ‘d:t:o,filename`. See Appendix C for further details.
    -d, –debug-info     Print debug messages on program exit.
    -e, –exec     Execute command and [...]

 
Site Hosted by Web Hosting UK | Dedicated Hosting