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
4  5508 
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******@bells outh.net> wrote in message
news:kN******** *********@bigne ws4.bellsouth.n et... 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
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******@bells outh.net> wrote in message
news:kN******** *********@bigne ws4.bellsouth.n et... 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
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******@bells outh.net> wrote in message
news:kN******** *********@bigne ws4.bellsouth.n et...
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
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******@bells outh.net> wrote in message
news:kN******** *********@bigne ws4.bellsouth.n et...
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: GuyInTn |
last post by:
Hi all,
I have been given the task of moving an sql database from one server
to another. These servers are not on the same network. I know I can
detach the database, copy it to a new location, then FTP it to the new
server and re-attach it.
My question is, is this the best way to do this? Or is there another
way? I have access to both servers through Enterprise Manager.
|
by: sumGirl |
last post by:
Hi all. I know that since you know nothing about my database it will
be a stretch to answer this - but does anyone have a boiler plate
checklist for moving a database, dts packages, agent jobs, etc...from
one server to another? Maybe something that just says I should at
least do x,y,z.
Also if anyone out there has any hard won experience/advice about
gotchas when doing this I would love to hear it. We have outgrown a
server and are...
|
by: barbara |
last post by:
We've all data and log files located in SAN mount point. In case of
primary server crash, is it possible to unmount the volumes and
remount at secondary server? Do we have any problems with master DB
moving this way. Detach,attach or backup/restore are not our options.
Thanks
|
by: Kay |
last post by:
Hello,
I have two list boxes on my form, one initially displays with items and the
other displays blank, by clicking a button, it is possible to move items
from one box to another and vice a versa, this works fine. I also have a
dropdown list on the page with autopost back = true, my problem is as
follows: when the user selects an option in the dropdown list the form is
posted back to the server and certain other processing happens, then...
|
by: Woody Splawn |
last post by:
I have been using SQL Server 2000 on my stand-alone machine as a back-end to
a VS.net application. It is time to switch environments and take the
application to the customer. I need to install SQL Server 2000 on the
server of the client's local area network, which is a Windows 2000 machine.
I am
concerned about doing this right. On my own machine I did the install
incorrectly at first and had to re-install. I had a very hard time...
| | |
by: UJ |
last post by:
I've got a working web service that we are moving to another machine and now
I suddenly get the following error.
While transferring the files, got the following message:
System.Web.Services.Protocols.SoapException: Server was unable to read
request. ---System.InvalidOperationException: There is an error in XML
document (1, 1422). ---System.Data.DataException: Undefined data type:
'anyType'.
at System.Data.XSDSchema.FindNameType(String...
|
by: rick |
last post by:
Hi
I m trying to move only stored procedures from one database to another
and also onto a database on another server, I tried
db2 -x "select text from syscat.procedures where procschema =
'MYSCHEMA'" | tee /esa/home/sasha/MY_SCHEMA_SP.txt, how ever all the
procedures are getting loaded to the file but some stored procedures
are getting truncated because they are too big ,
I also tried to use getroutine but the problem is we have 600...
|
by: gar598 |
last post by:
I don't have much experience moving these types of site, but we're
changing sites, and I've been asked to move the site to a new server.
It's your typical setup Windows server, ASP.Net 2.0., a few SQL
databases. Is there an easy/best way to go about this? Any insight
would be most appreciated.
|
by: mcjason |
last post by:
I saw something interesting about a grid pair puzzle problem that
it looks like a machine when you find each that work out the way it
does and say with all the others that work out the way they do
together overlapping common pieces but say connected each working out
as connected, but together as connected it's connected with the others
connected. a whole machine where connected together is a condition of
the machine together as...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
