Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 24, 2012, 11:37:40 AM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Access2MySQL  (Read 451 times)
masoud
Space Explorer
***
Offline Offline

Posts: 7


WWW
« on: November 23, 2002, 10:06:00 PM »
Hi there,

I've converted my Access mdb file with Access2MySQL and I've got SQL files on my HDD...
Now where to put these files ?
How to connect to the Lunarpages' SQLServer ?

Is it possible to generate these files directly in SQLServer, if so what to put in the host and socket number in Access2MySQL ?

Confused here, any help ?
Thx.
Logged
stephan
Guest
« Reply #1 on: November 24, 2002, 12:17:00 AM »
There is a section in the Control Panel, where you can backup, and load backups of SQL databases, I think that would be the place you want.

Alternatively, you can probably do what you want through phpmyadmin (also in CPanel)
Logged
masoud
Space Explorer
***
Offline Offline

Posts: 7


WWW
« Reply #2 on: November 24, 2002, 08:31:00 AM »
Thanks 4 the reply Stephan,

The Backup section didn't help me...

For the phpmyadmin, I tried to create my db with that and did it, but no success in connecting!
Error: Table mydb:mytable doesn't exist!!
I downloaded the phpmyadim from one site and put it in one directory in my site and created my db with it... it worked!!!  "[freak]"

Now, I don't know where is my db files.
I got the complete backup of my site but didn't find my tables in it.

Well, long story, but I'm thinking about leaving the Lunarpages.

Many many troubles with this hosting (email and ftp accounts, Chili!ASP and...)

Thanks anyway  "[Smile]"
Logged
stephan
Guest
« Reply #3 on: November 24, 2002, 11:05:00 AM »
If you e-mail support@lunarpages.com , I'm sure they will be able to sort something out for you.

The last thing we want is people leaving/dissatisfied customers.

If you e-mail support, your problem will be solved.
Logged
stephan
Guest
« Reply #4 on: November 24, 2002, 11:08:00 AM »
Perhaps you can have a look at the SQL files and see what is inside them.

Do they end in .sql ?

Perhaps they need to be executed, and contain a list of commands that will create tables. If so, then phpmyadmin will be fine.

Good luck. Let us know how you get on  "[mad]"    "[eek]"    "[frown]"  /   "[Smile]"    "[Big    "[Razz]"    "[Cool]"
Logged
Johnny
MR-Disabled
Über Jedi
*
Offline Offline

Posts: 1914
« Reply #5 on: November 24, 2002, 05:17:00 PM »
I will need to back up my database, including the tables, sometime this week, as nuke is coming out with a new release.

I've never done this before. Could someone explain to me, in a step by step method, how to accomplish this, and how I would restore the database, along with the tables, should the upgrade corrupt, delete... ect, it?
Thanks
Logged
Lunarpages Web Hosting

Lunarpages Forums

Lunarpapages Affiliate
Program

Helpdesk Ticket Submit

Helpdesk FAQ

Lunarpages FAQ

Have your say on our new phone support hours! (VOTE -
http://www.lunarforums.com/forum/index.php?topic=36844.0)

Telephone: 1-714-521-8150
Fax: 1-714-521-8195

whoisthis
stephan
Guest
« Reply #6 on: November 24, 2002, 05:33:00 PM »
Login to your CPanel

Click on "Access Menu"

Click on "Download/Upload backup file"

There, you should find links to:

Download today's backup (of the site)

and download/restore your SQL databases.
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: