Switch To Different Database Host Location
I am working on a JAVA project at the moment which requires me to have a command that can switch the MySQL database host to a different IP or Location without recompiling or restarting.
Would anyone know if there is a MySQL command that I could use for this?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Place Database At Other Location
I have created a database on my MySQL DBMS I have at home. Now I want to move a copy to a friend. How do I do that? In other words I want to copy the database to a CD. I've also got Navicat from PremiumSoft....perhaps its simpler to do from there? But I also want to know how it is done from mysql
Query Database From Remote Location.
I have a database sitting on my db server, which is part of my office network (which has a domain controller). Access to the outside world is via a router, which is well locked down. Currently, remote users access the database front end via Terminal Services but this is only a method of accessing an application stored and running on the Database Server. What I want to do is allow access to the database from a server, which is located in another building (another part of the country). This is essentially an inter/intranet server. What is the best way for me to get this external server to be able to query my database server?
MySQL Database File Location
I have a Windows 2003 Server and have installed MySQL 4.3.13-nt on it. I want to create 3 databases on it called d_one, d_two and d_three etc. My problem is that I want to use separate folders for each database. Let’s say, I want to store the database files for d_one at c:database1 folder, d_two at d:database2 folder and database d_three at e:database3 folder. Is this possible to achieve this? If yes then can I get some guidance on how to go about this.
Setting Local Database Location
I use Adobe GoLive for web dev and am now incorporating PHP scripting and MySQL databases. Everything works really well as far as functionality (first time using GoLive for dynamic site dev) but I'd like to have the MySQL database file for the site reside somewhere in the directory structure that GoLive sets up as opposed to the default location set in the MySQL .ini file. If I'm developing multiple websites, each with a MySQL database, how do I set things up such that each website's database resides in a different directory?
How To Upload Database To Host
I have a database 'foo' on my local machine that I would like to upload to a server where my website is hosted. How can I do that?
Access To Other Host Sql Database
I currently own a website with various different MySql databases. I use the mysql_connect ("localhost",""....) to connect. I would like to give another website access to this database. What would they have to enter in place of "localhost"?
Moving A My SQL Database To A Different Host
I have a number of databases and 3 hosts I am currenlty using. One of the hosts has too much down time and I would like to migrate the database before I address issues with him. I want to get the full structure and content across to my new host which had a much better time on line. I am using cpanel for access on the new one and Myadmin on the other both have my SQL and php running the interfaces look virtually identical from this persepctive. If I download from one and upload to the other should I just do a simple download upload operation or do I need to install the database in some way first. The help I've seen talks about command line access but the interface on each is a bit more WYSIWIG than command line so using the tutorial is proving to be interesting.
How To Switch Users
I tryed my sql manual and could not find a solution to my problem. when i open mysql command line client 5.x it prompts for root password and when supplied i loged in sucessfully. that is ok. my question is how to login as a diffrent user from mysql prompt? assume currently i have loged in as root and wanted to login as xyz.
Uploading My Database To Host Server
I have created a dump of my database using DB Tools. I then log into my server & from the cpanel I choose mysql admin tool. I then choose the SQL tab & choose the file & then get the above error!?!?! Code:
Connect To MySQL Database From Another Host.
I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost). While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","dbname","dbpassword") Now I am trying to find out what to use instead of localhost? I tried to replace localhost with host's url : port (I tried number of ports) but this is not working (even when I am connecting from DBhost itself). How can I find out what is the proper value to use instead of localhost?
Connect To MySQL Database From Another Host.
I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost). While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","dbname","dbpassword") Now I am trying to find out what to use instead of localhost? I tried to replace localhost with host's url:port (I tried number of ports) but this is not working (even when I am connecting from DBhost itself). How can I find out what is the proper value to use instead of localhost?
Switch Hosts And Preserve Records
I decided that my host isn't for me but I have a lot of sql info that I don't want to be lost. Is there some query I can use to get out all the contents of my database into a form where I can easily input it back into a new one?
Access Denied For User 'root'@'host' To Database 'db'
i'm trying to connect from a remote host to a db, and I just cannot. I can make a successful connection to another db (test), but not to the productive db. I have tried some things (flush privileges, grant everything), but I still cannot connect to the db.
Local Host Vs ISP Host Name In Connect Command
I'm having a problem figuring out how to configure my Connect command so I can test on my PC and upload scripts to my ISP without constantly changing the Connect command to reflect the applicable host. I use LocalHost on my machine and then change it to my ISP's IP on their network before uploading the scripts. I'm sure there's something I'm missing in the manual about setting up Grants.
Switch Query Logging While The Server Is Running
It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened. Otherwise, the server has to be restarted to change logging, which is a bit annoying...
Warning: One Can Only Use The -- User Switch If Running As Root
I started the mysql database with the "safe_mysqld" command and with the user who own mysql. in the errr-log file, I have that: 050123 23:16:50 mysqld started Warning: One can only use the --user switch if running as root /exlibris/sfx_ver/sfx_version_2/app/mysql/libexec/mysqld: ready for connections What is the meaning of "Warning: One can only use the --user switch if running as root" ?
Run DB From Another Location
Is it possible to move JUST ONE database, not all of them, to another location and have it running from there? I whant to put a db I have onto a mounted SAN volume, but keep the mysql database and everything else on the local machine. It's MySQL 5.0, running on CentOS 5.
Location Of Databases
In my default installation, it creates a folder for 'data' under c:mysql . If I want the data to reside under my local internet root directory, how do I tell Mysql where to find it?
Location Of A Row In Result
here's the problem let's say that I have the following table (msgs): id, cid, text 1, 1, text1 2, 1, text2 3, 2, text3 4, 1, text4 5, 2, text5 6, 2, text6 7, 1, text7 now if i executed the following query: SELECT id, text FROM msgs WHERE cid='1'; here's what I'll get id, text 1, text1 2, text2 4, text4 7, text7 but here's what i want to get counter, id, text 1, 1, text1 2, 2, text2 3, 4, text4 4, 7, text7 and then I want to know the location of the row that holds the id 4, which is 3 in this example. 1st: I have mysql 3.23 on my pc, and the new version of mysql is about 17-36 MB so it's hard for me to download it on a slow intenet connection, plus I don't know whats the version of mysql on my site server, so please suggest a solution that works for version 3.23. 2nd: I don't want to create temporary tables to find the results as many users at the same time could execute the same query, so the code might create thousends of tables at the same time. 3rd: I don't wanna use PHP code for this, as the result could return thousends of results, and I don't wanna go through loop for thousends of records. please any ideas? oh btw I want to display only 5 records but I want to know what 5 records to display depending on the location the certain row that i'm looking for.
Location Searches
How can I create a query that will search a database for a record based on a "location" field?
Scripts And Their Location
I have MySQL 5.0 loaded and would like to create some scripts to automate queries. Do they need to be in a specific location? How do I execute them from the command prompt (how do I tell MySQL where to find them)?
Move DB Location
Is there a way to change the physical location of the DB? I am running MySQL 5.0 on Windows XP and I would like the DB to be stored on another partition, but I can not for the life of me figure out if that is possible and how to do it.
DB File Location
I've looked all over the Administration GUI app (MySQL Administrator 5.0) and can't find where I tell MySQL to put my datafiles onto a seperate hard disk.
Location Of Databases
it creates a folder for 'data' under c:mysql . If I want the data to reside under my local internet root directory, how do I tell Mysql where to find it?
Install Location
I am going to be installing MySql on a Netware 6.5 server. We will be using MySql with Novell Audit 2.0. Can you change the location of the install folder for MySql. I would like to install it on a different volume than SYS. I have downloaded MySql 5.0 or should I used the MySql that comes with NetWare? I believe its 4.0.
Changing My.ini Location
I am making a setup that installs a mysql 3.23.39(the software that setup installs runs only with this version). The setup detects other mysql versions and if another mysql 4 or 5 is found setup installs my mysql 3 on a different port. The problem is if the other mysql(4 or 5) have its my.ini located in the systems directory(c:windows). This is a serious problem for me. So my question: Is there a way to change the path of mysql's (version 3.23.39) my.ini location. I want to put my.ini in mysql's 3 directory. In the registry for mysql 4 I can do something like this: "C:Program FilesMySQLMySQL Server 4.1inmysqld-nt" --defaults-file="C:Program FilesMySQLMySQL Server 4.1my.ini" MySQL4
File Location
I have a Windows 2003 Server and have installed MySQL 4.3.13-nt on it. I want to create 3 databases on it called d_one, d_two and d_three etc. My problem is that I want to use separate folders for each database. Let’s say, I want to store the database files for d_one at c:database1 folder, d_two at d:database2 folder and database d_three at e:database3 folder. Is this possible to achieve this? If yes then can I get some guidance on how to go about this.
Log Files Location
I have a normal? install of MySQL running on Windows. My tables are MyISAM. I was wondering where I might find log files of each transaction (if these are even kept) so they could be used in the event of disaster recovery.
Location Of Databases In Different Directories Possible?
This is really a newbie question so please bear with me. I provide virtual domain services to my clients. Up till now my clients MySQL databases have all been located in the usual single directory. However, in order to keep track of HD usage along with their /home/domainName usage, I thought that being able to place their individual databases in their own directory would be a neat solution. Is this possible? If so how? Or is there a better solution? Specs: VPS v2 MySQL Client API version 3.23.58
Get Cell At *specific* Location?
How do you get a value from a specific row, without fetch_array'ing until it has reached the row I want? I have a randomized MIDI player, I have a random number that tells which MIDI to play, but how do I get that from the database?
Changing The Information Location
I'm running mysql version 4.1.21 locally for my Java program to connect to. I would like to alter my system in such a way that the service could still be running on my actual local machine ... but the actual information will be stored on a mapped drive somewhere else.
Data Location Addition
using mySQL under Windows, there is a default data folder, ie pathdata. How to add additional locations on say another drive on same PC?
Alternate Storage Location
I am trying to change the location of my data storage for windows mysql 5.0, but mysql doesnt seem to want this to happen. I have tried doing this from both the administrator tool and directly editing my.ini, but once I make these changes and then start the mysql service I get a "Error 1067: Process terminated unexpectedly". From looking around, I see that this is a kinda common issue, but I cant really find very good answers on how to fix it. The mysql docs say to move my.ini to the windows directory, but that didnt help either. (I'm using windows 2000 sp4)
Storing A Reference To An Image's Location
If you insist on storing the actual image file in the database ( I recommend against it) then make sure you set the datatype to BLOB. As to your earlier question it can't really be explained better with a sample script. All you need to do is insert strings (varchar datatype) into the database. The strings you store will be the file name and the path to the image ie. ( "image.jpg" and "/home/images/" ). You would store the actual image file in some directory. All you store in the database is the information necessary to find the image. Code:
Data Location On Hard Disk
I have just installed MySQL 5.0 and finished the first test from a database application. I saw that the data is stored in c:program...MySQl... I am not happy with that. I want MySQL stores all data in a map of my own choice.
MySQL Password Hash Location
I'm running MySQL v.4.0 and and on my webserver and I have PHP Nuke installed. For the PHP Nuke system to run, it requires the db username and the db password. However, I can't use the text version of my db password, because my password actually gets hashed, and that's what is required by PHP Nuke. When I first installed the Nuke, I was able to locate my password hash, but it's been so long that I actually have no clue as to where I was able to locate it. I would change the database user password back to what it was...if only I could remember what it was. So, reverting it back to it's previous password doesn't look like it's going to be an option. So, basically...all I need is to find out where in the heck I can locate the hash for my db user password
File Link Location In Table Field?
how do you establish a file location in a mysql db? Say I have an picture located at c:picturespic1.jpg. I think the format is something like 'picturespic1.jpg' but i'm missing something. can someone assist?
Connecting To Mysql Using Phpmydmin From Remote Location
I just installed PHP 4.3.9, MySQL 4.0.2 and PHPMyAdmin 2.6.0-pl3 on our intranet server (Win2k3 running IIS). I also have a similar setup on my local machine (http://localhost/phpmyadmin). Everything seems normal when I work on the server machine (also known as web-nt with IP xxx.xxx.xx.xx), but when I try connecting to the MySQL database on the server from my local machine (http://web-nt/phpmyadmin), two things happen: 1. If I user 'localhost' in the phpmyadmin config file on the server, it opens up properly but obviously all the images are looking at http://localhost/phpmyadmin... etc, which is on my machine. 2. If I use the IP address on the config file, which seems to be the better method, I get the following error: #1045 - Access denied for user: 'root@web-nt.acorn.com' (Using password: YES)
Trouble Chanigng Mysql 5 Socket Location
How do I change the place where the mysql socket file gets created? I thought it was in the my.cnf file by changing the "socket" property. However, using MySQL 5.0 on my Fedora Core 5 Linux system, when I do this and restart, attempting to connect to MySQL through PHP gives me this error Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/apache2/htdocs/refillingstation/db.php on line 19 Can't connect to MySQL: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Here is my "my.cnf" file: [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql5.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid .
Host Name
how do i find the host name in all those files.
IP Host
How can I make MySQL to host on my real IP not on localhost? Do I have to install a program or something else?
Web Host
Does anybody know any web hosting companies that are currently supporting mysql 4.1 alpha? How is one able to utilize the subqueries feature found in mysql 4.1 when nobody seems to support it. Running my own server is currently not an option.
Help My Host Is Killing Me With This.
Ok, so I use Joomla! as my content manager system under the database itt_admin and I use SMF as my Forum under the database itt_forum. What I need to do is have it so that when users register on my Joomla! website it will automatically add that user to the SMF Forum website and vis versa. I normally would do this in cPanel by simply going to MySQL and going to the drop down menu and selecting user and then the other drop down menu and selecting my database and then clicking "add user to db" however, my Host does not offer cPanel. Sympliy I am only able view each individual MySQL database in phpmyadmin. So, my question is how do I bridge these two databases so it has the same effect as it would have if I had used that option with cPanel?
MySQL Host
Hey everyone. My company is building a new automotive search portal based on our Auto Web Engine script. The site is free and open to anyone to sell. We have a lot of our developer users already set to send vehicle data once it is up. It runs on php and mysql. The problem is, I can't find any dedicated servers or anything that give a good chunk of mySQL storage space, 100mb is all I can find. Does anyone know of any host that offers a good amoutn of mySQL space? We are already getting good reviews of our site as we are building it, so we anticipate a good amount of traffic and want to make sure I don't run out of room after a month or so..
|
TRACKER
