How to upload local mysql database to remote server?

Hi,

My environment is;
-Mac OS X 10.5
-DW CS4
-eCart5.01 on Mamp/PHP/MySQL.
-For mysql editing I ust "Sequel Pro".

So far, I figure what I need to do is;
1. save a back up file and upload it to host directly,
2. restore the backup file using SSL.

But I'm struggling dealing with SSL connection.
I wonder if there's any other ways to do this...

What would be the best way to upload the database I created on localhost server to remote server? (Any guidance to other resources will be much appreciated also.)

Thanks!

If you've gotten the SQL dump from Sequel Pro, you will just need to upload the file to the server and import the file there. If you are unsure how to connect to your server through ftp, you should contact your server administrator or hosting provider.

Hi Jimmy,
Thank you for a quick reply.

I know how to connect to the server via FTP (I use Dreamweaver or Fetch).
But What do you exactly mean by "import the file there" ?

Do I just upload the damp file to host directory and this will make mySQL database work??
Or do I have to do something else after I upload the file to the directory?

Have a look here:

Exporting and Importing a database using phpMyAdmin
150/

Hi Office Guy,

Thanks.
I see. I realize that my host server doesn't come with phpMyAdmin, I now have to start from installing it on the server.

After that, I guess it's all simple and easy as you and Jimmy says.

Aarrggg! Another hurdle to cross!

Thank you for your help anyway.

Sorry for not being clear on that. If you run into any additional issues, feel free to open a new thread.

Jimmy,

No biggie, I didn't mention about phpMyAdmin, either.
Sure I will come back when I have trouble.

Thank you all for kind supports!

I do this a lot!

Do an sql dump of your local db

Create a new database on the server
(assume you have some sort of control panel or remote server set up where your account is)
note server address, name, pw etc for this new db

enter online database details in Sequel Pro's prefs
make a new connection
that should open your database (all be it an empty one)
file - import your sql dump

done!

Assuming your database name and password are correct - ensure you online account will allow connect to its database(s)

You may need to set the online DB recipients list to accept your local address. It will be pretty obvious if you try to connect with SequelPro and the recipents list is required as you will get a message like

'MySQL said: Access denied for user 'YOURONLINEACCOUNTNAME'@'IP ADDRESS' (using password: YES)

the IP ADDRESS is the one you put in the online database recipients list

hth

Paul

Hello web_assist_mail157665,

Sorry for a very late reply.
But I've worked it out!
I had to figure out that my host blocks the direct access, so I needed to SSH tunnel, but it's all working fine.

This is great, I didn't have to go through installing phpMyAdmin...

Thank you very much for you info.

RikaG

I have a MSSQL export to a CSV file that I want to import into MySQL on our own server. I'm using HEIDISQL to manage the database.

Does anyone have the proper procedure for how to match up my CSV fields to MySQL? Is there an explanation of which PS3 fields are for what? What is the difference between PS3_Categories and PS3_productcategories?

Thanks for any help.

Paul