close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to upload local mysql database to remote server?

Thread began 3/15/2010 4:18 pm by rikaG_510 | Last modified 4/01/2010 1:38 pm by Eric Mittman | 1787 views | 12 replies |

rikaG_510

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!

Sign in to reply to this post

Jimmy Wu

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.

Sign in to reply to this post

rikaG_510

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?

Sign in to reply to this post

Office Guy-172461

Have a look here:

Exporting and Importing a database using phpMyAdmin
150/

Sign in to reply to this post

rikaG_510

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.

Sign in to reply to this post

Jimmy Wu

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

Sign in to reply to this post

rikaG_510

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!

Sign in to reply to this post

web_assist_mail157665

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

Sign in to reply to this post

rikaG_510

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

Sign in to reply to this post

Paul

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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...