2ninerniner2

@payyattil – as per forum rules, please start your own topic as it is unrelated to the OP.

@tony979 –

The database for any WordPress site is not, I say again, not, in any file in the file system on the hosting account (server). It is in a database which is located in another area of your hosting account, and one accesses is with the hosting account’s database admin tool, generally, a brand name tool named phpMyAdmin.

You mention that the site was/is hosted on GD. To create an export file, as Patty and vtxyzzy point out, you would have had to use the database admin tool in your GD hosting control panel to do so and download it to your computer.

If you still have access to your GD hosting control panel, then log in, find the database tool and export the database. Refer to GD’s help/support (Google it) for the exact procedure as it relates to your particular hosting account plan (older plans have a “home-rolled” hosting control panel as opposed to the newer Linux ones which now use a popular brand of hosting control panel, namely cPanel (a brand name, BTW).

Another choice is the Wappalyzer browser extension.

https://wappalyzer.com/

Identifies not just the CMS but other technologies as well.

I too have seen other instructions that say to create a new user and assign all privileges … and then I answer the database connection error posts here ??

On a local install I see no reason not to use the default user as long as one is not setting it up to be accessed from elsewhere; then of course one has to correctly do so.

Regarding the move to live:

When you set up the new, empty database on your hosting account into which you will be importing the export file from your local install you will be using the unique user of the hosting account. This is why, after the files are moved from the local site, one has to edit the wp-config.php now on the hosting account with the live site database connection credentials.

Here is a great place to look ??

https://www.ads-software.com/plugins/search.php?q=contact+form

Your entries (posts and pages) are stored in and retrieved from the database, which would be where your site was (is) hosted.

If you still have access to your hosting account, use whatever database tool their control panel offers to export the database.

No need to create a new database user; use the MAMP default ??

Re-name the wp-config.php file (e.g. wp-config_ORG.php) which will allow the installer to run again.

Assuming your MAMP installation is configured with it’s default settings:

Create a new, empty database

1. go to the MAMP Start Page – select Open start page from the MAMP Control Panel if the page is not already open in one of your browser tabs/windows

2. select phpMyAdmin from the Tools menu drop down or enter https://localhost:8888/phpmyadmin in a new browser tab/window

3. in phpMyAdmin, select the Databases tab

4. enter a database name (lower case, no spaces or special charaters – for this example I’ll use macwordpress1 ) in the Create database box then select the Create button

5. a notification will show that the above database has been created

6. notice that the new, empty macwordpress1 database is now in the list in the left side bar

7. close the phpMyAdmin tab/window as that is all there is to do for the database; the WordPress installer will create the necessary tables and populate them accordingly

Then start the install again:

– at the first screen, select the Create a Configuration File button
– at the next screen, select the Let’s go! button
– at the next screen enter the following:

— Database Name: macwordpress1
— User Name: root (this is the default MAMP database user name)
— Password: root (this is the default MAMP database password)
— Database Host: localhost
— Table Prefix: wp_ (leave as-is)

– select the Submit button
– All right, sparky! … select the Run the install button

Here is a great place to check out ??

https://www.ads-software.com/plugins/search.php?q=landing+page

1. At GoDaddy

– change your domain’s nameservers to the Bluehost nameservers; you will have received an email when you signed up with Bluehost which contains the 2 values, or view them here:

https://my.bluehost.com/cgi/help/1

– follow the instructions in this GD support link, second option:

Setting Custom Nameservers for a Domain Name Registered with Us

https://support.godaddy.com/help/article/664/setting-nameservers-for-your-domain-names

Note that is can take up to 48 hours for this change to become effective; this is normal.

2. You new WP site on Bluehost

– here is one of many tutorial which guide you through the process of moving your content from Blogger to WordPress:

https://www.fabulousblogging.com/2014/01/the-beginners-guide-to-moving-your-blog-from-blogger-to-wordpress/

Sound as though this would be a question for the Web Platform Installer forum ??

https://forums.iis.net/1155.aspx

Alternatively, you may want to consider a different local server “stack”, such as my personal fave of many years, Uniform Server, or other popular ones like XAMPP and WAMPServer.

Then there’s always the “long answer” ??

Local Site:

– export the database
– ZIP the contents of the site

Live Site:
– use phpMyAdmin (or your hosting account’s database tool) to create a new, empty database (no spaces in the name)
– import the exported local database .sql file
– edit the siteurl and home fields in the wp_options table with the new live site URL:

— https://www.my_domain.com

– upload the ZIP file and unZIP (or copy the local site files via FTP) to the desired location on the hosting account (generally the root of the account, public_html)
– edit the wp-config.php file there with the live database connection credentials (use the edit file option of your hosting account’s file manager to do so)
– log into the live site Dashboard:

https://www.my_domain.com/wp-admin

– install and run this plugin:

https://www.ads-software.com/plugins/velvet-blues-update-urls/

— select all options EXCEPT the last one (GUID)

– go to Settings > Permalinks and just re-save

– if broken links remain, then upload this script to the root of your hosting account and run it:

https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
— this script updates the URLs that are stored in the database as serialized strings, which the plugin mentioned above does not handle

– go to Settings > Permalinks and just re-save if you had to run this script and then delete it from your hosting account

Done ??

I know it seems like a lot of steps/work, but it is quite straight forward and provides one with a better understanding (hopefully) of what is going on and why.
Yes, there are plugins that do this, such as Duplicator and BackupBuddy, but again, one does not get a gist of what’s happening. And if something goes pear-shaped using them, then it’s off to the plugin’s support forum to find out what went wrong.

Using this method, which I always use, I can get a local site to live in under 5 minutes ??

Once the site is live and running tickety-boo, then please do as RossMitchell noted and that is set up a proper child theme of TwentyFouteen:

https://codex.www.ads-software.com/Child_Themes

Use phpMyAdmin (or whatever database tool you use or USBWebserver uses) to edit the siteurl and home fields in the wp_options table in your WP database. Enter the complete URL:

https://localhost:8080

One does additional installs of WP using Bitnami in the same way as other AMP (Apache, MySQL, PHP) “stacks” (XAMPP, WAMP, MAMP (Mac)) etc.

The only difference is that you had to have used the default settings for Bitnami during it’s initial install, that is, you had left the “phpMyAdmin” option enabled so that you are able to easily create new, empty databases for the additional WP installs.

Assuming you used the default installation path for Bitnami, your Bitnami web root is located at:

C:\Bitnami\wordpress-3.9.2-0\apache2\htdocs

– extract the downloaded WP ZIP package to this location
– a folder named wordpress will be created which contains all the files necessary for a WP site
– rename this folder to something else so as not to be confused with the initial and subsequent installs; no spaces in the name
– for this example, use wordpress2
– from the Bitnami control panel, select Open phpMyAdmin
– click the Databases tab
– enter a name in the Create database entry box and click Create
– for this example, enter wordpress2 (or whatever you like, just no spaces)
– start the WP installation by entering the following in your browser:

127.0.0.1/wordpress2

– click the Create a Configuration File button
– click the Let's go! button
– enter the following:

— Database Name: wordpress2 (or whatever you named it)
— User Name: root
— Password: the password you entered during the initial install for the WP log in
— Database Host: localhost
— Table Prefix: wp_ (leave as-is)

– click the Submit button
– your name should now be sparky! :-) ... click theRun the install` button
– complete the next screen as required; note to un-check the Privacy item for local installs
– click the Install WordPress button
– log in ??

The default Apache port setting for MAMP is 8888, which then gives you the URL of https://localhost:8888. If you are successfully accessing your server (site?) at https://localhost then you must have changed that to port 80 in the MAMP settings.

This will not create any problems when moving the site “live” as all the URLs will need to be changed once moved. Not to fret: there is a plugin for that, and one of the more popular ones, and the one I always use, is:

https://www.ads-software.com/plugins/velvet-blues-update-urls/

— select all options EXCEPT the last one (GUID)

Not sure what else to suggest as this is the method I have successfully used many times.

One thing that comes to mind now that you mention some plugins may be affecting this, is to deactivate them on the live site before exporting the database as the settings may be stored there and if so are usually done so as serialized strings, making them difficult to change directly.