پشتیبانی آنلاین
پشتیبانی همیشگی آنلاین جهت حل مشکلات شما
در صورت عدم رضایت از سرویس ارائه شده هزینه شما تا 7 روز بعد قابل برگشت است
تمامی سرویس های پی سی سرور از نظر کیفیت تضمین شده هستند
پشتیبانی تلفی برای همه مشتریان عزیز
پنل مشترکین
آدرس ایمیل:

کلمه عبور:


مرا به خاطر بسپار

شماره حساب ها
پرداخت آنلاین فوری
طرف قرارداد با بانک ملت
بانک ملت
Backup/Repair Huge Database's VPS/DED server
Backup/optimize/repair/recover large Databases on VPS/Ded server


A lot of people start a forum and dont know how to manage database maintaince, since there are a lot of autoposters your database soon grows in size and people cant manage it.

after you have >1million posts the database becomes harder to manage especially if you have problems with tables crashing etc.

  1. I will show you how to backup a big databse with ease, waz-warez database is 15GB and takes 4-5 minutes.
    • Close your board.
    • Purge your cache if your cms has one.
    • (Optional) Edit your forums config.php database connection file so no queries can be run while getting a backup.
    • Login to SSH
    • Navigate to your database in mysql folder. #cd /var/lib/mysql
    • Find your forums database folder #ls
    • Make a backup of the database folder #tar cvzf mydatabasebackup.tar.gz YourDatabaseFolder

    Now you have a complete database backup (without using MYSQL server) that can be restored in minutes if needed 

  2. Repair huge tables marked as crashed/in use with ease.

    When you are working with huge tables you may find your server/vps hangs when trying to run a phpmyadmin/ssh table repair so you need some other method.
    Over time I have seen some big sites just start over fresh due to database errors (snow hehe) eg.warezscene and this may have fixed there database.
    I recoverd warezusa database just over a week ago 
    • This presumes your post table is showing 'in use' or 'crashed' and you cant repair it.
    • Edit your forums database config.php file so your site cant connect to the database.
    • Backup your database See Above
    • Login to SSH
    • restart MYSQL service mysqld restart
    • Browse to your forums MYSQL folder and display files #cd /var/lib/mysql/YourDatabaseFolder;ls
    • Find the filename for your post table with MYI extension.
    • Run a repair on this file #myisamchk -r PostTable.MYI
    • When it completes you should be good to go.
    • Backup the folder 
تاریخ ارسال: 2012-05-18           تعداد بازدید: 2057           نویسنده: admin
طراحی سایت و انواع قالب

طراحی سایت

     برای ورود به بخش طراحی اینجا کلیک کنید