By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Moving DB to another server

P: n/a
I am moving a web site with a MySql database to another server. Can I create
a database on the new server with the same name and then move the tables
there, or is life not that simple? Or can I create tables with no data and
then replace them with the files from the other server? I know I can export
them as text files and them import them, but that is a lot of trouble.

Also, using my FTP program I can't access the mysql folder on the server,
but I can using SSH as the root user. If I can indeed just move the table
files, can I FTP to another folder then use the mv command in SSH to move
them, or will I run into permissions problems there too?

--
Thanks,
Stephen Ghelerter

Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Well.. to back up your data to a text file, you can use the mysqldump
utility (check out the mysql documentation) ONLY when you have access to the
mysql directory ON THE SERVER. However my problem is that I do not actually
have telnet access to the mysql folder, therefore I am unable to run this
utility on the server. Why can't I ask the guy operating the server to
accomplish this? Well, this is exactly why I want to do it myself - it's
been 2 weeks since I have asked him to back up the database, and guess
what.. no he hasn't yet started it!!!

My question is, is there actually any way to gain access to the server and
back up all the table definitions and the data myself? I can access the
database on the host server through the mysql client on my computer with the
username that guy gave me.. but that's about it.....

Any help will be appreciated

==James==

"Stephen Ghelerter" <gh******@bellsouth.net> wrote in message
news:kN*****************@bignews4.bellsouth.net...
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables
there, or is life not that simple? Or can I create tables with no data and
then replace them with the files from the other server? I know I can export them as text files and them import them, but that is a lot of trouble.

Also, using my FTP program I can't access the mysql folder on the server,
but I can using SSH as the root user. If I can indeed just move the table
files, can I FTP to another folder then use the mv command in SSH to move
them, or will I run into permissions problems there too?

--
Thanks,
Stephen Ghelerter

Jul 19 '05 #2

P: n/a
Well.. to back up your data to a text file, you can use the mysqldump
utility (check out the mysql documentation) ONLY when you have access to the
mysql directory ON THE SERVER. However my problem is that I do not actually
have telnet access to the mysql folder, therefore I am unable to run this
utility on the server. Why can't I ask the guy operating the server to
accomplish this? Well, this is exactly why I want to do it myself - it's
been 2 weeks since I have asked him to back up the database, and guess
what.. no he hasn't yet started it!!!

My question is, is there actually any way to gain access to the server and
back up all the table definitions and the data myself? I can access the
database on the host server through the mysql client on my computer with the
username that guy gave me.. but that's about it.....

Any help will be appreciated

==James==

"Stephen Ghelerter" <gh******@bellsouth.net> wrote in message
news:kN*****************@bignews4.bellsouth.net...
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables
there, or is life not that simple? Or can I create tables with no data and
then replace them with the files from the other server? I know I can export them as text files and them import them, but that is a lot of trouble.

Also, using my FTP program I can't access the mysql folder on the server,
but I can using SSH as the root user. If I can indeed just move the table
files, can I FTP to another folder then use the mv command in SSH to move
them, or will I run into permissions problems there too?

--
Thanks,
Stephen Ghelerter

Jul 19 '05 #3

P: n/a
BDR
Jeez, since you have regular server access, why not just install
phpmyadmin and then you can do anything you want with your data...
http://www.phpmyadmin.net/

Just install this thing via ftp, (that is if you've got php enabled on
your server), setup your username and pw and you're off and running.
You can create, dump do do, select ca ca... anything you want from this
web based front end and it only takes about 5 minutes or less to do it....

and it's free 2!
James Jiao wrote:
Well.. to back up your data to a text file, you can use the mysqldump
utility (check out the mysql documentation) ONLY when you have access to the
mysql directory ON THE SERVER. However my problem is that I do not actually
have telnet access to the mysql folder, therefore I am unable to run this
utility on the server. Why can't I ask the guy operating the server to
accomplish this? Well, this is exactly why I want to do it myself - it's
been 2 weeks since I have asked him to back up the database, and guess
what.. no he hasn't yet started it!!!

My question is, is there actually any way to gain access to the server and
back up all the table definitions and the data myself? I can access the
database on the host server through the mysql client on my computer with the
username that guy gave me.. but that's about it.....

Any help will be appreciated

==James==

"Stephen Ghelerter" <gh******@bellsouth.net> wrote in message
news:kN*****************@bignews4.bellsouth.net...
I am moving a web site with a MySql database to another server. Can I


create
a database on the new server with the same name and then move the tables
there, or is life not that simple? Or can I create tables with no data and
then replace them with the files from the other server? I know I can


export
them as text files and them import them, but that is a lot of trouble.

Also, using my FTP program I can't access the mysql folder on the server,
but I can using SSH as the root user. If I can indeed just move the table
files, can I FTP to another folder then use the mv command in SSH to move
them, or will I run into permissions problems there too?

--
Thanks,
Stephen Ghelerter



Jul 19 '05 #4

P: n/a
BDR
Jeez, since you have regular server access, why not just install
phpmyadmin and then you can do anything you want with your data...
http://www.phpmyadmin.net/

Just install this thing via ftp, (that is if you've got php enabled on
your server), setup your username and pw and you're off and running.
You can create, dump do do, select ca ca... anything you want from this
web based front end and it only takes about 5 minutes or less to do it....

and it's free 2!
James Jiao wrote:
Well.. to back up your data to a text file, you can use the mysqldump
utility (check out the mysql documentation) ONLY when you have access to the
mysql directory ON THE SERVER. However my problem is that I do not actually
have telnet access to the mysql folder, therefore I am unable to run this
utility on the server. Why can't I ask the guy operating the server to
accomplish this? Well, this is exactly why I want to do it myself - it's
been 2 weeks since I have asked him to back up the database, and guess
what.. no he hasn't yet started it!!!

My question is, is there actually any way to gain access to the server and
back up all the table definitions and the data myself? I can access the
database on the host server through the mysql client on my computer with the
username that guy gave me.. but that's about it.....

Any help will be appreciated

==James==

"Stephen Ghelerter" <gh******@bellsouth.net> wrote in message
news:kN*****************@bignews4.bellsouth.net...
I am moving a web site with a MySql database to another server. Can I


create
a database on the new server with the same name and then move the tables
there, or is life not that simple? Or can I create tables with no data and
then replace them with the files from the other server? I know I can


export
them as text files and them import them, but that is a lot of trouble.

Also, using my FTP program I can't access the mysql folder on the server,
but I can using SSH as the root user. If I can indeed just move the table
files, can I FTP to another folder then use the mv command in SSH to move
them, or will I run into permissions problems there too?

--
Thanks,
Stephen Ghelerter



Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.