Exporting SQL offline database from Desktop Server

sticker · 11-01-2019 12:18pm #1

Hi,

I'm using Desktop Server for Wordpress offline work - I have created a database with Blacknight and uploaded the wordpress files to my domain directory and entered the correct config.pho file also.

BK support tell me I need to export the database from my local computer and import to new database with BK.

Any idea how I achieve this?

Thanks.

Kenny Logins · 11-01-2019 1:15pm

From the PHP myadmin panel. I don't know how your local server is setup, but there should be access to this somewhere. For example Xampp has a MySQL "admin" button.
Don't forget to update all of the URLs before importing. You can do this in a decent text editor.

Graham · 11-01-2019 1:31pm

Desktop Server has a few methods for making deployment to a production server easier:

Direct Deploy appears to be the easiest option:

https://serverpress.com/using-direct-deploy-to-launch-websites/

sticker · 17-01-2019 10:52am

Thanks for your replies guys. I was ill so unavailable to reply earlier. Apologies

I've just bought a new Linux package with BK and I'm working through a Lynda.com course - very interesting!

I have downloaded the root files for wordpress, uploaded to my domain via Filezilla and created a database, I can see that I can edit on the fly with the server, add themes.widgets etc...

What the upside of using Desktop Server at all?

seamus · 17-01-2019 11:37am

sticker wrote: »

What the upside of using Desktop Server at all?

1. It allows you to screw around - make changes and test changes without affecting your live site. If you make a balls of something, delete a file by accident, etc, then there's no panic to get your live wordpress site back up because it's happily unaffected.

2. You can work on it without an Internet connection.

In any environment you typically have 3 stages (though big sites often have more);

- Development - lives in an environment like Desktop Server where you can make and test changes and reset them again without affecting anything

- Test/PreProd - typically lives online or at least in the same environment as your live site. Changes are copied from development to here. This allows you to test not only the changes you've made, but also the process for moving those changes from Dev into a new environment

- Live/Prod. Once you're satisfied that the test site works the way you want, you backup the live site and push the changes. There should be no surprises, because the purpose of the test site is to find surprises.

Of course, if this is just a hobby or a small site, a test environment may be overkill. But if you value the site you're building in any way, then you need a development environment where you make all your changes separate to your live one.

sticker · 17-01-2019 11:45am

seamus wrote: »

1. It allows you to screw around - make changes and test changes without affecting your live site. If you make a balls of something, delete a file by accident, etc, then there's no panic to get your live wordpress site back up because it's happily unaffected.

2. You can work on it without an Internet connection.

In any environment you typically have 3 stages (though big sites often have more);

- Development - lives in an environment like Desktop Server where you can make and test changes and reset them again without affecting anything

- Test/PreProd - typically lives online or at least in the same environment as your live site. Changes are copied from development to here. This allows you to test not only the changes you've made, but also the process for moving those changes from Dev into a new environment

- Live/Prod. Once you're satisfied that the test site works the way you want, you backup the live site and push the changes. There should be no surprises, because the purpose of the test site is to find surprises.

Of course, if this is just a hobby or a small site, a test environment may be overkill. But if you value the site you're building in any way, then you need a development environment where you make all your changes separate to your live one.

Many Thanks Seasmus. I'm new to databases offline and on!

I could setup the Environment with Lynda, but my issue was I could not export the offline database and import it to Blacknight.

I assume I still create a blank SQL5 database ion my Lunux hosting, but I need to occupy it with the offline database on my PC...

How is this done? - Please explain like I'm a 5 year old!

seamus · 17-01-2019 12:21pm

I'm afraid I don't know the specifics of the software that you're using. In general it is basically just a matter of exporting the offline one and importing it into the online one.

If it's MySQL, then Desktop Server should include a backup/export option, and the Blacknight PhpMyAdmin interface includes an import option.

In all seriousness if you google "exporting MySQL database from desktop server to phpmyadmin" you might get a guide for it, or at least some helpful guidance on the next steps.

sticker · 17-01-2019 12:23pm

seamus wrote: »

I'm afraid I don't know the specifics of the software that you're using. In general it is basically just a matter of exporting the offline one and importing it into the online one.

If it's MySQL, then Desktop Server should include a backup/export option, and the Blacknight PhpMyAdmin interface includes an import option.

That actually rings a bell! I think there is an export facility. What kind of file is a exported database file extension - is it just a single file?

seamus · 17-01-2019 12:24pm

For MySQL, it's basically a text file with a .sql extension. It may also zip the file by default after exporting (makes it smaller). PHPMyAdmin will take either the raw text file or the ZIP file.

sticker · 17-01-2019 12:37pm

seamus wrote: »

For MySQL, it's basically a text file with a .sql extension. It may also zip the file by default after exporting (makes it smaller). PHPMyAdmin will take either the raw text file or the ZIP file.

Thanks again!

shane7 · 18-01-2019 2:17am

It should be pretty straightforward. In localhost on your desktop server you should see an option for php-myadmin. Click that and it should take you to a list of your databases. Once you can see your databases click on the one you want to export.

On the tabs across the top you should see an option to export. Click the export tab and scroll down to go and click it. That will download the sql file to your download folder.

You now do the opposite on your blacknight server. Go to database you have created in phpmyadmin and go to the import button. Browse to the .sql file in your download folder and upload. You then just need to go to the config file and edit your username and password.

If you get an error after you have uploaded the .sql file its usually a mistake in the config so check and double check you are using the right database name, username and password

sticker · 18-01-2019 6:56am

shane7 wrote: »

It should be pretty straightforward. In localhost on your desktop server you should see an option for php-myadmin. Click that and it should take you to a list of your databases. Once you can see your databases click on the one you want to export.

On the tabs across the top you should see an option to export. Click the export tab and scroll down to go and click it. That will download the sql file to your download folder.

You now do the opposite on your blacknight server. Go to database you have created in phpmyadmin and go to the import button. Browse to the .sql file in your download folder and upload. You then just need to go to the config file and edit your username and password.

If you get an error after you have uploaded the .sql file its usually a mistake in the config so check and double check you are using the right database name, username and password

Many thanks Shane

Exporting SQL offline database from Desktop Server

Comments