|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 7th, 2005, 11:49 AM
|
||||
|
||||
|
Export mySQL DB
Hi all,
I have a mySql Database, and I need to shift it to my hosting company. they said I must export the database to a textfile and import it again using the web control panel, but I have no idea how to export the database and tables. I have tried doing through the mysql control center but the export table command is disabled? Any help would be appreciated.
__________________
Look! Its a ShemZilla    
|
|
#2
February 7th, 2005, 11:57 AM
|
||||
|
||||
|
I would suspect they may mean do a select * query and dump the results into a text file, using some sort of script. If you can connect to your database from outside your webhost, you could create an identical mySQL database and simply copy from one to the other.
|
|
#3
February 7th, 2005, 12:02 PM
|
||||
|
||||
|
Hi,
I must get the CREATE TABLE ..... stuff into a text file and run it through the control panel, I can't connect from here to the server. Do you know of a way to extract the create statment for a table?
|
|
#4
February 7th, 2005, 12:05 PM
|
||||
|
||||
|
have you got phpMyAdmin installed on your webserver?
if not get it here I think it will be able to give you the sql to create the tables
|
|
#5
February 7th, 2005, 12:10 PM
|
||||
|
||||
|
Thanx for the input, will do so.
they say my quota is full anyway, so have to sort out that first. Thanx again. Cheers
|
|
#6
February 7th, 2005, 12:42 PM
|
||||
|
||||
|
removed IP Address
Thanx, I got it working. The database is up but not running
 on the hosting site they say this MySQL 4.0.20-standard running on sql3a.your-server.co.za as easycp_1@196.7.147.32 but when I try to connect with this, it doesn't work Code:
conn.Properties("Data Source").value = "someIP";
conn.Properties("Initial Catalog").value = "web_CPD"
conn.Properties("User ID").value = "test"
conn.Properties("Password").value = "test"
any ideas? Last edited by nofriends : February 8th, 2005 at 04:03 AM.
|
|
#7
February 7th, 2005, 03:03 PM
|
|||
|
|||
|
Maybe the mysql port is blocked by a firewall?
You may want to edit out the actual server IP and name in a public forum.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#9
February 8th, 2005, 12:10 PM
|
||||
|
||||
|
hosts usually will give you instructions regarding the setup of phpMyAdmin, because its such a common tool, try contacting the host tech support and see if they have dissalowed its use, and/or can point you in the directions of help files.
TBH I had some difficulty setting it up as well, and rely upon file system permissions to keep out the riff-raff!
|
|
#10
February 9th, 2005, 01:36 AM
|
||||
|
||||
|
Thanx for all the help guys,
I was using the wrong IP Address in the connection  All working now. cheers
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > Export mySQL DB |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
