Support » Localhost Installs » transferring website to another computer

  • Resolved rachel0666

    (@rachel0666)


    Hello,
    Im using xampp. I backed up the entire xampp folder with all of its contents, including the site itself. Here`s the issue: I didnt back up my database. It had no tables and I know the name if that is of any use. After installing xampp on the new machine and replacing the xampp generated folder with my backup, I can start the app, access localhost, but when I try to access my site, it says error establishing connection. Fixed that by creating a new database with the exact same name I used, making it identical to the previous one. But when I try to access my site, it kicks me into wordpress installation. After I fill in the missing info and proceed, it says wp is installed and so it lets me log in aaaand. The site is wiped. All the plugins are installed, but deactivated, all my pages, posts, and all the plugin settings are wiped. I tried this with my backup and one even older than that, but nothing works. I know however that this is error on my part as I got the previous backup running once before without exporting the database. Any help please?

Viewing 5 replies - 1 through 5 (of 5 total)
  • A WordPress website with a Database without tables will by definition not work.

    It can’t;
    WordPress is a dynamic CMS that takes most of its data and details to run out of the database. For example, active plugins and themes are stored in the database, or a Blog Name, or a Username, etc etc, they are all in the database.

    There are a default amount of tables in each WordPress Database table, and thus, they get instantiated whenever you “set up” WordPress.
    If the database was empty and your site was running just fine it can only mean one thing: that was not the database it was using.

    You can find the database name it was using in the wp-config.php file, in the DB_NAME constant. That will at least give a clue as of what database was used, and you might then be able to locate it in the XAMP env.

    I myself use MAMP, so there I have a tab in the App (Databases) and can also access them under the URL http://localhost/phpMyAdmin/?lang=en, which then shows me all my Databases and I can export them from there.
    Maybe that helps to locate yours, and export it.

    Next time, to migrate a WordPress website, you could also use a tool like Duplicator, or any other “Backup/Migration” plugin, which allow you to migrate entire WordPress websites with a few clicks

    • This reply was modified 2 months, 2 weeks ago by Beda.
    Thread Starter rachel0666

    (@rachel0666)

    Oh, sorry I am quite new to webdev 🙂 Ok, I think I understand what you mean. Is there a way for me to somehow get it working, with only the xampp folder backup and nothing else please?

    Not if you do not have that database.
    The database is vital to any dynamic website, it holds all the things unless PHP code which is stored in the FTP Files (and uploaded files, as in /uploads)

    The rest is in the database and without it, there is unfortunately no way to recover that data.
    It is as if you deleted the FTP files – they would be gone. Similar with the Database, if not there, the data is gone.

    Unless you manually deleted it in XAMP, the database is still there. So try to locate it in the XAMP app (as said in MAMP there is a tab that shows all databases and from there you can also reach the PHPmyAdmin area to dump it)

    Thread Starter rachel0666

    (@rachel0666)

    Seems that we totally didnt understand each other. Maybe I messed up in the terminology… How I fixed my issue was by copying mysql folder from my xampp backup into my current machine. I dont know why it didnt work before, as Ive copied the whole backup.. but regardless, resolved.

    mySQL is a open-source relational database management system
    In other words, its what is used to manage your database.

    PHPmyAdmin on the other hand is a software written in PHP to manage mySQL…

    So by copying the mysql folder, you likely also got your actual database back.
    That is basically the same as going into PHPmyAdmin and dumping the database, then adding it to your new host

    Nice that you got it back working, nothing more annoying than lost work 😉

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.