Problem with Backing up a webportal's database

Discussion in 'MySQL' started by talasgr, Jul 2, 2008.

  1. #1
    Hi, I am running a webportal on a linux server (debian 4) loaded with php4 and mysql 4.0.18.

    The webportal consists of two parts: one is the presentation system which is what the user sees (the website) and the other is the administration system (control panel of the site).

    I am using mysqldump to backup the database issuing the following comand

    ./mysqldump -u root -p culturedb > cullture.sql

    To test if the backup works i use another server where i load the backup.

    Now the site (presentation system) works fine but the administration system does not take the username and password. So it is like the login information of the site's administrator is not backed up.

    Someone suggested me that whatever passwords are saved on the server under the etc directory at a file called shadow. So i copied the file from the main server to the test server but still i have the same problem.

    Does anyone know how can i solve this problem ?

    Thank you and iam sorry for my bad english
     
    talasgr, Jul 2, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    I believe the other server has MySQL version >= 4.1. If this is the case, then you are suffering from this http://dev.mysql.com/doc/mysql/en/Old_client.html
     
    mwasif, Jul 2, 2008 IP
  3. talasgr

    talasgr Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi, I think the test server runs 4.12 version of mysql
     
    talasgr, Jul 2, 2008 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    mwasif, Jul 5, 2008 IP