Access Slaved Hard Drive In RH Linux
I have a MySQL db on a RH Linux hard drive that will not boot...I slaved it onto another Linux box and need to pull up the db in the slaved drive...
I do see the second hd as hdc1 in GNOME but can not open it??
I REALLY do need to get/copy the db and load into another working box.
View Complete Forum Thread with Replies
Related Forum Messages:
Hard Drive Space?
I have recently installed mysql to be the backend of a websystem. The system tracks and bills about 500 customers. I have it installed on a hard drive with nearly 4 gigs of free space. It was recomended to me that i move the mySQl datafiles to a different hard drive with more space, but 4gigs seems like plunty to me. Does anyone know if i really should move it or if 4gigs will be acceptable? If i should move it, anyone have any tips on moving it without uninstalling, reinstalling and rebuilding my tables?
View Replies !
Timing Out :: CPU And Hard Drive
When I look at MySQL in the Windows task manager I see that it isn't using much CPU power, nor is anything else. However, my hard drive light is going non-stop when I try to load a page and whenever the page times out it is always on a line of code fetching a query result from the database. What could MySQL have suddenly started doing that even simple queries require vast amounts of hard drive usage?
View Replies !
Moving Databases From One Hard Drive To Another ?
I have a hard drive that fails to boot with some mysql 4.1 data I would like to keep. Have slaved that drive to another PC (with mysql 4.1.12 loaded) and have saved other data and am able to access its MYSQL folder ... I tried to copy the data folder into corresponding directory on new drive but when I try ot look at any of the databases I get errors like: #1017 - Can't find file: 'master_name.MYI' (errno: 2) ... I look for corresponding .MYI files but cant find any on the old drive. Have I lost my database files or is there another way of porting the database to the new drive.
View Replies !
Restore DataBases To 2nd Hard Drive
Platform FreeBSD 4.9 on a Dell PC. I Ghosted the drive to a secondary disk and put it on the secondary IDE channel. What I want to do is, after the dump of all databases takes place, I want to temporarily mount the secondary drive and restore the databases to it. This would be a nightly proccess run by cron. I know almost nothing about MySQL and am not sure if this is even possible. I thought about doing the following script I wrote but, isn't there a nicer way to do this? mysqldump --opt --all-databases > /smx01/profile-mysql.sql echo "MySQL dump is complete......." ;; newfs /dev/ad1s1g mount /dev/ad1s1g /mnt/backups/ad1s1g cd /mnt/backups/ad1s1d restore -ruy -f /smx01/usr-local_dump1 /mnt/backups/ad1s1d cd umount /dev/ad1s1d echo Restore to secondary hard drive complete!
View Replies !
Mysql Filling Up Hard Drive?
I have a table with about 36 million records that is about 1.8GB in size. I am trying to perform the following query on it: SELECT query, count(distinct(id)) FROM data group by query; I am running it via the command line and piping the output to a file to use later. The problem is when it runs mysql fills up my entire ~30GB hard drive (I checked the free space while the query was running) and then spits out the following error: ERROR 3 (HY000): Error writing file '/tmp/MYQ9Q6ci' (Err 28) I doesn't seem to be when it is outputing the results that this happens, it is still performing the query (output should be well under a gig). Also, no files are created so it must be all mysql temporary stuff I guess. I have tried the same query using a WHERE clause that restircts it to a few throusand results and it works fine when I do that. I currently don't have any indexes on the table. I will try adding one to the query field. Anyone have any ideas why it is filling the hard drive and what I could do to fix it?
View Replies !
Recover Database From Crashed Hard Drive -- Using Win Xp And MYSQL 5.1
My system crashed recently and I had to format the computer. I am using Win Xp. I wasn't able to create a dump file of my database but I was able to copy MYSQL folder from All usersApplication DataMYSQL and also from Program Files MYSQL. Is there a way I can recover my database (tables, functions, and data) from these folders. I really need to recover it.
View Replies !
How Do I Setup The Server On A Network Drive For Client Software To Access?
I'm building a database system for our department at work and have successfully installed the MySQL Server 5.0 to my local machine and developed my user interface to access it read/write/update, etc. just fine through VB6 and the ODBC driver. My problem now is how do I get the database files and server functions moved/transplanted/installed on a network share drive (Windows 2000) that my peers and I have access to, so that I can deploy me client user interface onto their machines so we can all access the database across the network and I can get the files off my local hard drive?
View Replies !
Linux And MySQL Access
I know MySQL account has nothing to do with Linux system account. I just wondering is there a way when I creates a new Linux account it will automatically creates a MySQL database account? Or do I have to write my own shell script to do that?
View Replies !
Mysql Access Yellow Dog Linux
i have a problem similar to others in this group but this is a little bit different. i am running mysql on my yellow dog linux server, but for some reason whenever i try to connect, it gives this error: [root@powerpig root]# telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. NHost 'localhost.localdomain' is not allowed to connect to this MySQL serverConnection closed by foreign host. [root@powerpig root]# .
View Replies !
Java In Linux (Redhat 9) To Access MySQL
Using a Java program, I can connect to the test database in MySQL. The test database is installed using a MySQL utility, and it can be accessed by any user without supplying a password. The relevant lines in my Java (Java version 1.4.1) code are: Connection con = null; String url = "jdbc:mysql:///test"; // <== no user or password specified con = DriverManager.getConnection(url); However, when I try to connect to the accounting database (built as one follows the Larry Ullman's "MySQL" book), the program fails. I need to supply a user and a password. The relevant lines are now: Connection con = null; String url = "jdbc:mysql:///accounting?user=root&password=pswd"; // <== con = DriverManager.getConnection(url); I cannot get a connection. The error message is: "Invalid authorization specification: Access denied for user: 'root@thorvald' (Using password: YES)" (thorvald is my machine name.) I have tried all sorts of variations on the url, trying to access the accounting database, with no success. I can use the same user/password of root/pswd within the mysql monitor to access anything I want. Any ideas? Again, I am using Linux (Redhat 9) , Java 1.4.1, MySQL 4.0.13, and the MySQL ConnectorJ 3.0.8 (for Java access to MySQL).
View Replies !
Hard Disk
When I sucessfully create a databse in the MySQL command line client, where exactly in the C drive does the database gets stored? I created a databse and than I used the windows search functionality to search for that databse. I am getting a result that says the database dosen't exist. But when I type in the show databases; command in the command line client, it shows that the databases exists, but I would like to know where.
View Replies !
External Hard Drives
I'm using Windows MySQL 5.0 on XP. I have an extremely large project that I was hoping to use some more disk drive space then the 50 gigs I had available, so I got an External 500G USB 2.0 Drive. I redirected the databases, and everything starts up fine. However, I noticed that when executing queries on the external drive compared to the local hard drive, the CPU is cut in half and large queries actually stall the service. I'm sure it has to do with the reading and writing to the USB device vs the local hard drive. I'm just not sure how and if I can fix it or troubleshoot it.
View Replies !
Another Easy(for You, Hard For Me) Select/join
Table 1 indexed on ID. Table 2 is a chat log. Colums: From, To I'd like to find out who is NOT chatting. So, I'd like to select all ID in Table1 that are NOT found in either column From or To in Table2 So far I'm using two selects, but this doesn't seem right.
View Replies !
Remove Hard Returns In DB Field
I have a simple PHP page that is adding data to a mysql database (longtext as the type). Now as it stands - when a user presses "enter" then add more text, the results (when displayed) have a hard line return. How do I modify this behavior? I just want it to be captured exactly as the user enters it.... IE - press enter and the text starts on hte next line, and hit it twice, and it shows up 2 lines below with a space in between.
View Replies !
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.
View Replies !
Moving Mysql To Another Hard Disk
I have a web based intranet application (php) that uses a mysql database. The server has just had a new drive added to it and am looking for a way to move the database from the current c drive to this new drive.I'm looking for a way to either: move the entire database to the new drive (in which case do i have to do anything within the code - the database name is still the same and i'll presume another drive is still localhost can) Can i just make Mysql save data into the new drive (and also move just the old data file to the new drive leaving everything else as it was).
View Replies !
Entering Data Into Db With Hard Returns
I have a html textarea where user submit text and it gets stored in a db. For example: This is a test. Here is my list... one two three See, the text has hard returns in it, but when i output it back on the page with php, it all goes into a continuous line. How can i have the hard returns in the output. Like I have the '' included.
View Replies !
Drive By Insert
When a script is doing an insert into a table, from what I'm seeing, the script can not continue on it's way until mysql says "ok, I'm done, the data's inserted". So, my question is...is there anyway for, PHP in this case, to pass the insert query and NOT have to wait until the database is done with that thread?
View Replies !
Drive Image And Mysqldump?
We regularly make drive images of our entire server and store it at a backup site. To be honest I have never fully understood how the imaging programs deal with open files. My question is will the drive image make a good copy of MySQL DB or should I be running a mysqldump before doing the drive image?
View Replies !
Move Database To A Different Drive
I originally installed MySQL 5.0 on my C drive to learn and figure out how to integrate. Now I want to go live and move it to our agency's share drive. I moved all the folders over, but when I add or drop databases they get added to or dropped from my C drive, not my share drive. What am I missing?
View Replies !
Drive Designation - Low Space
We have 3 databases connecting to this Windows server with MySQL version 3.23.51. I have MySql and the Data installed on the D drive of my server. It is running low on disk space. I would like to start using another set of drives for additional space, they will be set as another drive letter, E. Is it possible to have MySql look at data on 2 drive letters. My ini file, c:windowsmy.ini notes the following: [mysqld] basedir=D:/mysql #bind-address=192.168.1.1 datadir=D:/mysql/data set-variable=max_connections=300 #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=D:/mysql/bin/mysqld-nt.exe user=xxx password=xxx
View Replies !
Starting On Local Drive
I've a reasonably large site, about 300 static html files and including half a dozen pages indexing them for users under different categories, that I'm considering converting to php4 and mysql. My domain is hosted by Earthlink. I've seen instructions for building a database from the command prompt, but I doubt Earthlink allows command-line access to the server. I've seen instructions for using php to build a database; it sounds fine for adding new records but a nightmare for creating the large database I'd need just to begin. Can I create a database locally and ftp to the server everything I need? Obviously it'd be easier still if I could create it in Access and migrate, which I'm trying to learn about as well, but I don't see the ftp question covered.
View Replies !
MySQL On A Network Drive Error
I want to install the current version 4.0.13 of MySQL on a Win2000 machine in a directory different to the default (C:mysql). It should be a network drive, as this is backed up by our IT staff. I install the package using setup.exe and selecting "Custom" but just clicking OK on the following dialogue. As directory I selected something like "H:....MySQL_4.0.13". The package is installed correctly. I can install the service (mysqld --install) and see it in the Service catalogue of Win2K. However, when I want to run the service with "net start mysql" an error occurs: System error 65 has occured. Network access is denied. I checked the security settings on the directories, but I had the change priviledges. Setting them to "full access" didn't improve the situation. MySQL only works when I install it entirely on C:. What am I missing here? I would like the installation to reside on a network drive for the reasons outlined above.
View Replies !
DATA Folder On External Drive
I have one question: my DATA folder has been moved to an external drive, simple plug & play for Windows XP. At night I simply turn off the drive and that's it. If I need it, I power it back on. Last night to test, I shut the drive off, then powered it back up. MySQL couldn't find my schemas. Reboot and everything is fine. I plan on testing this for a while just to be safe. Anyone see any long-term problems with MySQL and the drive suddenly being un-available ? Any suggestions ? (like shutting down via admin prior to power-off).
View Replies !
Restore Databases From Crashed Drive
Trying to restore some mysql databases that were on a hard drive which has crashed. Although the DB's were supposed to be backed up. It appears they were not backed up properly as I can access the drive but can only find the FRM files. There are no MYI or MYD files on the old drive. Is it still possible to restore my databases and tables with just the FRM files ??
View Replies !
MySQL Data On A Mapped Network Drive
I would like to have MySQL use a mapped network drive. I'd like to do this in case there is a failure of the mysql machine, I can just replace it with a new machine pointing to the same network drive.
View Replies !
Table "hard Links" Under Windows
I am attempting to create "Symbolic" or as windows calls it "hard links" for some tables in a database. I have 2 databases, db1 has a users table that I created a 'hard link' to in db2. I created this using this program which ads shell intiration for hard linking: http://www.elsdoerfer.info/=ntfslink The hard-link appears to work, I tested with a simple .txt file and i can make changes to one file and open the other and see them. The 2 databases were working fine for awile after I created these hard-links, then things started to go wrong. It seems whenever I try to add a new row to the users table in db2 (with the hard-link) the change doens't show up in the same table in db1. It also corrupts the table. And same the other way, I added a bunch of users into the table in db1, then did a CHECK on the users table in db2 and it gives me this "Size of datafile is: 6872396 Should be: 6874300". So it seems part of the data is being written, since it knows what it should be. I read that one can do this type of setup in linux with symbolic links, maybe it doens't work with windows hard-links? It seems it should... maybe i'm missing something?
View Replies !
Using &quot;load Data Infile&quot; Command With Network Drive
I installed MySql 5.1 in local in a machine running Windows XP. I have some problems trying to load some data from a local txt file, with "load data infile" command(http://dev.mysql.com/doc/refman/5.1/en/load-data.html). The file is located in C:mysql_test and I defined a network drive mapping W: to the same directory. In this way I can access the file in two ways: - C:mysql_testmyfile.txt - W:myfile.txt I tried: - load data infile 'C:mysql_testmyfile.txt' ... ---> works - load data infile 'W:myfile.txt' ... ---> returns a file not found error The reference manual says that the "load data infile" command is executed on the server so all the paths used must be referred to the server. But in my case, the server is installed in the same machine of the client application (the console). Why the server can't see the file using W:myfile.txt? The reference manual tells about an option "local" to be added if you have to access a local resource instead of a remote resource on the server. So I tried: - load data local infile 'W:myfile.txt' ... ---> works (obviously) Why the server can't see the file using the network drive mapping, while can do using the normal path specification, even if everything (the server, the file to be accessed and the network drive) is local?
View Replies !
Can Access Remotely, Cna't Access Locally (seems Backwards)
I have a database that I am trying to connect to a schema called lportal4_1_2 in mysql 4.1.13a (provided by my hosting company) runnning in fedora. I am trying to get a container to connect to it and was having problems. Since I didn't want to pollute the problem with the container, I wrote a small (hack) program that does the connection. Here is the problem: I can connect from my desktop (winxp) using a Java command line application, Mysql Administrator and mysql query browser and everything works fine. When I run the same Java command line app (using the exact same driver) I get the Access denied for user error that follows: ---- java.sql.SQLException: Access denied for user 'lportal'@'inkbrains.com' (using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)...........................
View Replies !
Can't Access Created DB's Via PHP, Though Can Access Them Via PhpMyAdmin
I can create databases via mysql-shell and edit them. These then do show in phpMyAdmin and are editable. BUT, if I try to access these db's via a normal php-script (i.e. $ergebnis=mysql__list_dbs($server)), it only shows me one database, the test-db. (To show them, I use a for-loop which counts the elements in $ergebnis from 0 to the number smaller than mysql_num_rows($server) and then prints the string.)
View Replies !
Cpanel Can Access But For Others Access Denied
I can access my database through Cpanel's GUI with no prob, but when I tried using MySQL-front in my comp, it always give me an error access denied. I supplied correct username and pass but still no luck. and How do I configure MySQL-front to connect to my webserver's mysql db?
View Replies !
Win To Linux
I have set up a website on a windows machine using PHP MySQL but I want to port this over to a Linux machine. Is it possible for me to simply copy over the MySQL data files e.g. .frm .myi .myd files over to the Linux machine and place them in the appropriate folder after creating the database?
View Replies !
GUI For Linux
suggest the best GUI of MySQL for Linux with Store Procedure support(Create/Update). Better if also supports triggers etc.
View Replies !
Linux
i installed mysql(usr/local/mysql) on linux but its not starting showing me error like Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) though mysql.sock file exists(linked) in tmp directory wont helped me.
View Replies !
Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3 in particular? My goal is to do no harm to my current 4.1 setup. Can the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql commands for running multiple versions?
View Replies !
Upgrade From 3.23 To 4 In Linux
I have an installation of MySQL 3.23 located in /usr/local/mysql.3.23.51, which is working perfectly. Now I installed in /usr/local/mysql.4.0.14 the binaries for a new version (4.0.14 of course), and don't know how to start using it instead of the older one. I have a link: /usr/local/mysql pointing to /usr/local/mysql.3.23.51 and some few databases in that directory. My data files are in MyISAM format. How do I migrate the database files? How do I tell Linux to use this version? I never did a task like this in Linux, for I always used MS Operating Systems, so please be as clear as possible... In fact, I didn't understand the MySQL manual about this topic.
View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I can not seem to get any of the functions working on it. So I have now dopwnloaded the latest version hoping that this will fix the error. I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but i'm getting the following error message when I install MySQL-server-4.0.1-0.i386.rpm : Code:
View Replies !
Low Performance With Linux SMP
I use #mysql -V mysql Ver 12.21 Distrib 4.0.15, for suse linux (i686) with a SMP-kernel When I used this version with a kernel not SMP mysql was very very fast but now with the SMP-kernel the mysql is very very slow. I takes several minutes to make an INSERT on a table with near 50.000 Records Is there any problem with mysql an SMP? is a problem of the version I have installed?
View Replies !
|
TRACKER
