Apache Web Hosting Question (dropped the other questions for now)

[episodic]

If you are on an Apache webhost where you can only create the databases through the direct admin panel, and if/when you move to another webhost, how do you take your databases with you if you can't see them in your current webhost's directories and if the next webserver makes you create the database this way as well (hope that was clear). . .

 

[episodic]

I left off the other questions hoping for at least a reply to this one. . .

 

[InverseOfNeo]

You might be able to ask the current webhost to make the file (database) available to you. Not sure if that would help but thats my thought about it.

 

[RossMAN]

Export it with phpMyAdmin (login to DA then select MySQL Databases you will see a phpMyAdmin link).

I have known people to successfully move databases from DA to other web hosts who use Ensim, Plesk or cPanel.

 

[episodic]

Originally posted by: RossMAN
Export it with phpMyAdmin (login to DA then select MySQL Databases you will see a phpMyAdmin link).

I have known people to successfully move databases from DA to other web hosts who use Ensim, Plesk or cPanel.

Ok I see that, and even tested it by download a .gz verson of the database. What bothers me is on the import at another host, when you create the database often it has to be something like username_forum - if you have a new username on the 2nd host will the database and script still function correctly?

 

[Templeton]

Originally posted by: buyer262000

Originally posted by: RossMAN
Export it with phpMyAdmin (login to DA then select MySQL Databases you will see a phpMyAdmin link).

I have known people to successfully move databases from DA to other web hosts who use Ensim, Plesk or cPanel.

Ok I see that, and even tested it by download a .gz verson of the database. What bothers me is on the import at another host, when you create the database often it has to be something like username_forum - if you have a new username on the 2nd host will the database and script still function correctly?

Most scripts out there will have a config file where db info is stored (username, password, db name and host). If these are scripts you're writing yourself, get into the habbit of putting info like this into central files, not buried in the code somewhere.

 

[randomlinh]

actually, i was wondering the same thing sort of. my export of a compressed database didnt' work for somereason... i just did a text file and ran the commands in phpmyadmin. worked nicely.

but yeah, if a script doesn't have that ability to change the variables... i think you might be out of luck. although, maybe you can get the text dump and manually edit it... lots of room for error there though.