469,319 Members | 2,431 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

Moving DB to another server

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
4 5200
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
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
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
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.

Similar topics

1 post views Thread by GuyInTn | last post: by
1 post views Thread by barbara | last post: by
5 posts views Thread by Kay | last post: by
6 posts views Thread by Woody Splawn | last post: by
8 posts views Thread by rick | last post: by
1 post views Thread by gar598 | last post: by
15 posts views Thread by mcjason | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.