Home

Mysql'den veritabanı yapısını almak

By nerkn - February 23rd, 2009
Tagged:  

Sadece veri tabanı yapısını çıkartmak istiyorsanız. Ve phpMyadmin kullanamıyorsanız (ki ayarlanabilir bir çok özelliğe erişemiyorsunuzdur), mysqladmin yardımınıza koşabilir:

mysqldump -u kullanıcı -pşifre –no-data db_adı > yedek.sql

Yüklemek de ters şekilde:

mysqldump -u kullanıcı -pşifre db_adı < yedek.sql
yapılabilir.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
                     888     d8b   .d8888b.   d8b 
                     888     Y8P  d88P  Y88b  Y8P 
                     888                 888      
  8888b.   88888888  888888  888       .d88P  888 
     "88b     d88P   888     888   .od888P"   888 
 .d888888    d88P    888     888  d88P"       888 
 888  888   d88P     Y88b.   888  888"        888 
 "Y888888  88888888   "Y888  888  888888888   888
Enter the code depicted in ASCII art style.

Similar

  • New technique to win olimpics -

    New technique to win olimpics

    By nerkn - July 27th, 2010
    Tagged:  

    At the 1968 Olympics, Dick Fosbury took the athletics world by surprise with an unusual high-jump technique.

  • Printing mysql_error -

    Printing mysql_error

    By nerkn - June 23rd, 2010
    Tagged:  

    This is a code snipped to print mysql error.
    If there is no error mysql_error returns null, thus if evaluates false and there is no output.

  • multiple ON DUPLICATE KEY UPDATE -

    multiple ON DUPLICATE KEY UPDATE

    By nerkn - May 25th, 2010
    Tagged:  

    Here is an example of how to update multiple columns using values supplied in the INSERT statement. This assumes that column 'a' is the unique key.

  • multiple ON DUPLICATE KEY UPDATE -

    multiple ON DUPLICATE KEY UPDATE

    By nerkn - May 25th, 2010
    Tagged:  

    Here is an example of how to update multiple columns using values supplied in the INSERT statement. This assumes that column 'a' is the unique key.

  • php unlink recursive -

    php unlink recursive

    By nerkn - May 19th, 2010
    Tagged:  

    The shortest recursive delete possible.

    <?php
    /**
    * Delete a file or recursively delete a directory
    *
    * @param string $str Path to file or directory
    */

    • Fotoğraf Web