Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Exclamation Unanswered: Importing and exporting content - myphpadmin

    Hello!

    My website was hacked so I had to reinstall evertything. I exported the old database from the old website _espiritorock (the name of the old database), and imported into the new database (_espiritorock12). But the content I really needed didn't come in the import, which was the Jomsocial content, I mean all the tables jml_community, about 53 tables.

    Since I install a fresh version of Jomsocial all the tables are there but empty.

    The databases are within the same phpmyadmin in Hostmonster account, so I can see that the old information is inside the old database but after I export it doesn't show in the new one.

    I did again the export, now only of the tables I want. I saved in my desktop and inside the new database I clicked import, looked for the file I downloaded and after a while it says import was successful. But again, the content is not there.

    Since I have never done this before I don't know what I am doing wrong.

    Any help would be greatly appreciated.
    thanks

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    I would start by looking at the file that is generated by the export to see if the database is included in there. It could be that you are exporting only the structure and not the data.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Sep 2007
    Posts
    18
    yes I think you are exporting only structure and not data...

  4. #4
    Join Date
    Jun 2012
    Posts
    2
    Hello!

    When I exported I chose the Structure and data option. I've done it more than 5 times already.

    After looking at you responses I tried to export only the data since apparently all the structures (tables) were there but with no data.

    I got an error. And the files weren't there once more.

    I'd be willing to PM someone with my cpanel login info if anyone would be kind enough to do it for me because I have no clue of what's wrong. I've attached some pics to show what I did and the error I got.
    Attached Thumbnails Attached Thumbnails Captura de Tela 2012-06-25 às 14.54.20.png   Captura de Tela 2012-06-25 às 14.54.33.png   Captura de Tela 2012-06-25 às 14.55.24.png   Captura de Tela 2012-06-25 às 14.57.23.png  

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    can we actually see thge files that imporeted successfully

    my guess is that this is a rtemote accoutn and you may well have timeout problems (ie the file is to big for the time the ISP allows you to connect via PHP, or the file is to big. you need to talk to the ISP and get their co operation. ideally get them to do the dump and restore
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •