how can I transfer my MySQL database from my localhost to my WebSite??

My app(Done with Delphi) uses a local MySql database in home netWork Environment. Several users can access my database  at the same time from within my home NetWork.
I wish be able to transfer my database to my WebSite so my database will be accessed from users from everywhere.
I have a website powered my Servage.net and have what I need to access my domain.
Please I need step by step directives in order  to transfer my database to my website. I am actually use MySql WorkBench!
Thanks in Advance
bish wakimAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
Logon to MySQL Workbench

Export
- Select Server => Data Export
- Select the database you want to dump from the dialog by checking the appropriate checkbox
- Select "Export to Self Contained File"
- Browse to where you want the file saved
- Check OFF "Skip Table Data" (bottom right)
- Click Start Export
(You will be asked for your DB password during this process)

Clean Export
- Open exported file and remove first two lines
CREATE DATABASE  IF NOT EXISTS `YOURDB` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `YOURDB`;

Open in new window


Importing depends on what is available on your server - if you are able to connect via WB then do as follows
Import - WorkBench
- Select Server => Import
- Select Import from Self Contained File
- Browse to file saved in step 1 above
- Select target database from "Default Target Schema" dropdown
- Click Start Import.

Import - PHPMyAdmin
- Logon to PHPMyAdmin
- Select Database from DB list on the left
- Click Import
- Click Browse and browse to the file you saved in step 1
- Click Go
NB With most PHPMyAdmin installations you can upload a .zip of your SQL file. If you use this option your file must be named
XXXXXX.sql.zip
Where XXXXXX is a name you choose
bish wakimAuthor Commented:
It seems this is what  I need. I will try and come back to you later!
Thanks
bish wakimAuthor Commented:
Hello again Julian
I need answers to some Questions in order to proceed:
1. in the export section I did not see bottom right to check off "Skip table data"
2. do you mean I can use import-WorkBench only without using import-PHPMyAdmin?
3. I think I succeeded to export my database to a location in my computer. I am using FileZilla to access my web site. So what then? is it enough that I upload my database file to there?
Please don't let me down!
thanks
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
If you read through Julian's directions carefully, you'll require a step in your hosting setup to...

1) Create an empty database.

2) Import your data into your empty database.

For this you'll normally use phpMyAdmin or commands to directly create + load a database on the command line. Something like this...

db-create --dbname=foo --dbuser=foo --dbpass=MEGnuXScxyk6Xlr9
pv foo.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf --default-character-set=utf8 foo

Open in new window


You can't use sftp for this. You'll use a specific tool or command sequence designed to create + load your database.

Also, if you use a CMS like WordPress, you can use a backup/restore plugin like Duplicator or BackupBuddy, which create a zip file + installer file, so in this case you just create an empty database using your hosting panel system or phpMyAdmin + then copy the .zip data file + installer.php file to your site using sftp + navigate to the installer.php file with a Web browser + follow all instructions presented to you.

If this is your first time going this process, you might consider hiring someone to assist you.

Have them make a video of all their steps, so you can do this yourself in the future.
bish wakimAuthor Commented:
Yes this is my first time. I thought it would be simple.
You are right. I had better hire someone to assist me.  
may you help me to find somebody?
Julian HansenCommented:
1. in the export section I did not see bottom right to check off "Skip table data"
ss137.jpg
2. do you mean I can use import-WorkBench only without using import-PHPMyAdmin?
It is either or - you did not specify how you access your server DB so I provided both methods
3. I think I succeeded to export my database to a location in my computer. I am using FileZilla to access my web site. So what then? is it enough that I upload my database file to there?
No, FileZilla is for moving files - it knows nothing about Databases. You need a DB aware process (PHPMyAdmin, Workbench) to load the data into your db. If your host uses CPanel you should be able to access PHPMyAdmin from there

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
https://www.experts-exchange.com/gigs/ is one place providing good assistance.

I just read up on Delphi, as I've never used it.

Might be best to consider how you'll deploy your Delphi code also. It appears you'll require some sort of hosting which will support running whatever executable code is emitted from your Delphi compiler.

Likely this will require installing additional code libraries to support Delphi.

https://community.embarcadero.com/blogs/entry/configure-delphi-and-redhat-or-ubuntu-for-linux-development provides some related detail.

Before investing time moving you database, best create a simple Delphi Hello World Program + deploy to your hosting company + ensure you can even run Delphi code.

In general, if you're just starting a project which will have a long life span, might be good if you talk with someone who's been a developer for decades + talk with them about your application + best target language for you to use.

I've been writing code since since 1982 + I can tell you this is the first time I've ever heard of Delphi.

If a client asked me about Delphi, I'd say it might be useful for proof of concept work, not a long term project which had to run on the Net + which will have to scale (large traffic), if project is successful.
bish wakimAuthor Commented:
Hello David
As a matter of fact my application should not run in the web. However with the help of FireDac component  it is possible to retrieve data easily from my WebSite(This is what I need)

Thank you for you both. I will try to transfer MySql file to my WebSite using WorkBench.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.