Activity Stream
48,130 MEMBERS
35 ONLINE
KwwHosting On YouTube Subscribe to our Newsletter KwwHosting On Twitter KwwHosting On Facebook KwwHosting On Google+
Results 1 to 7 of 7
  1.    sql backup problem   sql backup problem sql backup problem
    #1
    Member

    Default sql backup problem

    i have a few diffrent sites on my server i can a full sql backup from phpmyadmin no problem.
    now when i try to get a sql backup from share4life it dls 2.6mb then fails
    oh thats gzipped if its zipped then it 987kb if its just the text file ill get the whole backup at around 80mb
    does anyone have any idea why this would be?

    some help here could go down well
    clarksta Reviewed by clarksta on . sql backup problem i have a few diffrent sites on my server i can a full sql backup from phpmyadmin no problem. now when i try to get a sql backup from share4life it dls 2.6mb then fails oh thats gzipped if its zipped then it 987kb if its just the text file ill get the whole backup at around 80mb does anyone have any idea why this would be? some help here could go down well:) Rating: 5
    Respected and Trusted People: UltimA - Dman - Ak47 - Whoo - CyberDeViLZ - HaxoR - jayfella - jjj - HAWK = <3






  2.   Sponsored Links

  3.    sql backup problem   sql backup problem sql backup problem
    #2
    Member
    Have you got ssh access?
    Extremely helpful article about hiding your identity here

  4.    sql backup problem   sql backup problem sql backup problem
    #3
    Member
    yes i have
    ive been talking with a friend and he thinks its a gunzip problem and that there are some commands that need running to fix it
    my self have no idea
    Respected and Trusted People: UltimA - Dman - Ak47 - Whoo - CyberDeViLZ - HaxoR - jayfella - jjj - HAWK = <3






  5.    sql backup problem   sql backup problem sql backup problem
    #4
    Member
    I find backing up or restoring from phpmyadmin is the worst possible way.
    1. It's slow as hell.
    2. The connection somtimes times out, making you have to restart the whole process again.

    Try using these commands.. they have never failed in the past for me

    Backup your database:
    mysqldump --opt -Q -u dbusername -p databasename > /path/to/backup.sql

    If you need to zip it up, use this command to tar and gzip up your folder or file:
    tar -zcvf newfilename.tar.gz /path/to/fileordirectory/to/compress

    Hope no errors will popup
    Extremely helpful article about hiding your identity here

  6.    sql backup problem   sql backup problem sql backup problem
    #5
    Member
    thank you lease i will give this a go and let you know how i get on
    Respected and Trusted People: UltimA - Dman - Ak47 - Whoo - CyberDeViLZ - HaxoR - jayfella - jjj - HAWK = <3






  7.    sql backup problem   sql backup problem sql backup problem
    #6
    Member
    Np, just remember to change directories bfore zipping it up, or the .gz file will end up in some other folder
    Extremely helpful article about hiding your identity here

  8.    sql backup problem   sql backup problem sql backup problem
    #7
    Member
    Well phpmyadmin is very annoying to retore big databases 10MB and higher.

    Try to used MySQLDumper
    Code: 
    http://www.mysqldumper.de/en/
    It is script used to backup and restore the database, it make things go easier.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 17th Apr 2012, 06:55 AM
  2. Unable to restore backup using Wp complete backup
    By Jayzzy in forum Webmaster Discussion
    Replies: 13
    Last Post: 25th Mar 2012, 03:32 PM
  3. Fileserve Copying (Backup) Problem
    By F A S T E R in forum General Discussion
    Replies: 4
    Last Post: 31st Dec 2011, 11:19 AM
  4. Backup Mod Like KWWH Uses
    By speedofpain in forum IP.Board
    Replies: 4
    Last Post: 27th Feb 2011, 06:49 PM
  5. DB backup problem from Server
    By swapnil0545 in forum Server Management
    Replies: 13
    Last Post: 2nd Mar 2009, 11:25 PM

User Tag List

Tags for this Thread

BE SOCIAL
sql backup problem sql backup problem sql backup problem sql backup problem sql backup problem