problems with database

  • ronitdeep

    (@ronitdeep)


    14 years, 9 months ago

    i have just changed my host, as my old host was down. they have provided me a separate backup of database (in tar.gz format) and home directory format.

    now i am not able to extract the tar.gz format database.
    how can i convert then in to sql format?

    consider me newbie.
    i have already extracted this database..
    after extracting it gives me multiple files.
    how can i reupload them all in one piece?

    attaching image make this question more clear..

    http://img106.imageshack.us/img106/2562/capturewiz005.jpg

    best regards

Viewing 1 replies (of 1 total)
  • MichaelH

    (@michaelh)

    14 years, 9 months ago

    That backup represents the actual files you need for the database, they are not what is know as a .sql backup.

    Ask your host if they will restore those to the necessary folder for your database (most hosts don’t give you access to the place you would have to put those files).

    If your host will not do that for you, then install something like XAMPP on your local machine then put those files in the appropriate data folder. For instance on my local xampp install, those files are in the c:\xampp\mysql\data\wpdata folder. At that point then use phpMyAdmin to backup your database and that will create the .sql file necessary to import/restore at your host.

Viewing 1 replies (of 1 total)
  • The topic ‘problems with database’ is closed to new replies.