I cant find my database

  • Hi, so I have a MAMP set up where I had wordpress running and all was well as I was developing a site. Then I wanted to put it onto an ftp server and make it live. I have never uploaded a wordpress site before, although I have uploaded non wordpress sites. However I could not make it work, and somewhere along the way my data on my local environment, or at least my access to it has disappeared and I am completely lost. I was following online instructions and was making some changes to the wp_config.

    I have a mac with timemachine. I went back before I made these catastrophic changes. I had made a child theme, and its still there and I can and have activated it. The CSS is still there. If I go through the file structure I can see the images I previously downloaded in the file structure however they are unavailable in the wp admin. I can see the custom CSS acting on elements. Its just all the content is gone within the WP admin, and the layout has gone.

    I go into phpmyadmin which I have next to no experience with, however in the side column on the left has a list of databases, i think; mysql, information_schema & performance_schema. None of these seem to house my data. I have been slamming my head against this for a few days now and the last thing I do is post a question, and here I am. I really have basically no idea how to fix this right now. I went back to the previous version, pre the changes, and it still doesnt work. How can this be? I am looking at having to recreate the site from close to scratch and that is going to be a lot of work. Any help will be appretiated here.

Viewing 1 replies (of 1 total)

  • Your “timemachine” has probably done its job and you have a set of files which match your working development site before you attempted to upload it. What it has not restored is the WordPress database, you should have been doing snapshot backups of it as you developed your site, this is easy to do using “EXPORT” in phpmyadmin.

    I hear you saying that you can’t find your database using phpmyadmin. You need to look at your “wp-config.php” file, it will have the database name, go into your localhost phpmyadmin and you will find it there, are you sure you were not looking at your webhost phpmyadmin ?

    You need to get your localhosted website going again, redoing whatever work has been lost, it will go much more easily the second time, I have done this. Once you are happy with it, backup the files and backup the database. The FTP all of your files to the hosting, the only file that gets changed is wp-config.php, it needs the database name+user+password for the database you created on the hosted site.

    Now use a plugin like DUPLICATOR to assist with moving your WordPress database.

Viewing 1 replies (of 1 total)
  • The topic ‘I cant find my database’ is closed to new replies.