Saturday, February 27, 2016

mysql database restore backup

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql backup: C:\Parallels\Plesk\Databases\MySQL\bin>mysqldump.exe -u admin_user -pPASS
S admin_database > c:\file.sql

restore:
mysql -u user -p database < file.sql

MYSQL Query cache
http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm
http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html

8 comments:

  1. Our Delhi Escorts one of the oldest and trusted Escort agency in Delhi We have lots of high class models for erotic fun.

    ReplyDelete
  2. The escort scene in surat is at this time booming. As of right now, there are quite correctly hundreds of escort agency donation their wares right from end to end the surat area. The require is high; the maximum it’s ever been, in fact. More so than ever, men are longing for the supplement of ravishing escort beauties for all method of events, shows, dinner and, of course, illicit behavior.
    hotel service escorts
    kurukshetra model escorts service
    sexy female escorts in gurgaon
    shimla model service escorts
    jammu call girls service
    ranchi model service escorots
    bangalore high class escorts
    cheap rate escorts in mysore

    ReplyDelete
  3. Greetings from Mumbai! My name is Dipika. I live in Mumbai for a long time, i am working in Mumbai Escorts I come from Turkey. I’m 27 years old. Before I talk about my physical characteristics, I am a girl with a turban, as you can see in the photos. I offer housewife escort in Mumbai. I have a shaped physique and perfectly shaped hips. I have huge breasts and a sexy newly married housewife escort service in Mumbai. if you are get more fun with our sexy call girl service in Mumbai. so visit our website dipikachaudhry.com.

    ReplyDelete
  4. We have an assortment of butterflies in her adolescence, who is working as proficient Call Girls In Surat to handle you and wealth. Numerous of them had a place from a legitimate family lesson. They are tricked in this commerce to create simple cash and riches duos. However within the starting of their career, they act so much most out of control, that's why we serve that sort of Russian Girl Escort In Surat to an energized individual, who have the capabilities of making cherish like an evil presence. To urge top-notch services one must enlist our escorts for greatest delight to meet mind-boggling encounters unless you need to unleash a suitable implies of getting a liberal offer of wild excellence. Really, they adore to twist down in bed to perform infamous acts with you. Our Surat Escorts Agency likes a man who is full of vitality to succeed throughout the love-making travel to induce satisfaction in an incredible way. Enlist us to urge moment secure affirmation from our modestly displayed dreadful lassies to live up to your impulsions. soreng-escorts
    south-sikkim-escorts
    tashiding-escorts
    thangu-escorts

    ReplyDelete
  5. Your ability to combine in-depth research with practical examples and real-world applications makes your content not just educational but also highly relevant, allowing readers to immediately see the value of what they are learning and apply it in meaningful ways.

    TV Series Jackets

    ReplyDelete