LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 01-30-2004, 10:12 AM   #1
acos7
LQ Newbie
 
Registered: Jan 2004
Location: Australia
Posts: 2

Rep: Reputation: 0
Angry connecting to remote MySQL server


I cannot tell you how much frustration this will save me. So, if anyone can help with this, I'd be indebted.

SITUATION:
I currently created a LOCAL MySQL database (in WinXP), using PrimeSoft Navicat, which is a complete, very powerful GUI environment with which to create all MySQL files, access rights, import from a range of other databases, etc.

The database works perfectly on my Intranet.

PROBLEM:
I cannot FTP-it into the my Domain's MySQL directory that is hosted remotely.

I do not have Write Rights to the database folder created under the mysql folder, and - though I can see them and attempt to change them - the changes are not allowed.

QUESTION:
Has anyone managed to upload an existing MySQL database into their Domain that is hosted by a web host organisation?

ANY help would be most appreciated.
The prospect of keying in thousands of existing records manually is depressing.

Acos7 - Harris.
 
Old 01-30-2004, 10:17 AM   #2
angst6
LQ Newbie
 
Registered: Jan 2004
Location: Toronto, Canada
Posts: 2

Rep: Reputation: 0
try using the mysql gui to execute the sql table script.

http://www.mysql.com/downloads/mysqlcc.html

that what i used.
 
Old 01-30-2004, 11:37 PM   #3
acos7
LQ Newbie
 
Registered: Jan 2004
Location: Australia
Posts: 2

Original Poster
Rep: Reputation: 0
Smile Navicat is a million times better!

Hello angst6,

And thank you for your reply.

I use PrimeSoft Navicat which is a million times better, more power and easier to use GUI.

The problem is that the actual remote folder that contains the MySQL files does not give me the WRITE rights, and does not allow me to change them either.

So, I'm stuck.

I also discovered that the Remote Host uses mysql.sock (socket). So, the database users I set up, etc., I cannot use, because I cannot upload the MYSQL.* files that MySQL generates for database access.

Any ideas, I'll try, as it'll otherwise mean hundreds of dollards in a remote Web Host that's useless to me.

With many thanks in advance for any help,

Harris.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a remote unix/linux server arunsri Linux - General 1 03-08-2005 09:01 PM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
Connecting to a remote server Mossaiby Linux - Networking 5 07-30-2004 03:38 PM
Connecting Mysql Database on remote server akamol Programming 4 10-16-2003 11:46 AM
Connecting to remote server tracey Linux - Newbie 1 08-11-2003 07:41 AM


All times are GMT -5. The time now is 03:30 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration