MYSQL :: Starting On Local Drive

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?

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?

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?

How To Run A Database Off An External Hard Drive?
i've got mysql 5.0 and I have 50 million records in a text file on an
external USB 2.0 hard drive. I can import the file into a mySQL
database on my laptop - but I don't want the database on my laptop. I
want that database to be physically located on that usb connected hard
drive instead of my laptop. Can anyone tell me how to set up the
database on my laptop, but with a physical location of the data on the
external hard drive? Oh - not that it helps, but I'm using Navicat (my
first day using it).

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!

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.

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).

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.

Receiving Beep From Hard Drive
I am working with MySql 5.0

if the command is wrong for it can't connect I receive a beep from my hard drive, is that a normal thing?

Exporting Databases From An Offline Drive
I have a hard drive that contained my website (pulled from my webserver and mailed to me) - I need to find out how to export the databases I had installed on it, and upload to my new server.

How Do I Move MySQL Database Files From Drive C: To D: ?
When we installed MySQL 5.0.45 (on Windows XP), we took the default installation directory specifications, which placed our MySQL instance's data files in:

C:Program FilesMySQLMySQL Server 5.0data

Our C: drive is full. We have 140 GB of free space on D:. We would like to relocate our MySQL "...data" directory onto the D: drive.

We have been unsuccessful in locating in the documentation how to make this happen.

Can someone please either"

1) direct me to a link in the doc to accomplish this or

2) post the steps we must follows to successfully relocate the contents of our "...data" directory from C: to D:?

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.

Data On Separate Drive From Program Files
I have a server that I want to run MySQL on. The server has a 6.4gb hard drive for the OS and applications and a raid array for data that is shared via samba.

What I want to do is install MySQL on the 6.4gb hard drive but have all the DATA saved to the raid array.

Load Apache/mySql On External Hard Drive
How can I load Apache,mySql,PHP on an external usb hard drive then move the unit to a pc with winxp and firefox and use the setup.

Moving Database To Separate Drive After I Installed Mysql 5
I am trying to move my db data directory from /var/lib/mysql to /mounted_drive/mysql on a redhat 4 EL box. I am running mysql 5. I found a site with some pretty good instructions but it seems that they may be outdated. Code:

Drive Failed Now Mounted As Slave How To Recover Db's??
I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I
copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I
fix this????

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?

Just Starting
I'm interested in developing an application using MYSQL. I've been out of the developer market for quite a while, but my background is mostly Oracle based technology with a lot of exposure to object, Java and XML.
What tools are in favor these days for use in...
1 - Modeling an application (data, object, process, services....) as well as generating the application.
2 - End user design for web based applications
3 - Administration tools to monitor what's going on
4 - Debugging tools
5 - Documentation

Int Field Starting With 00
I have a database and in the one table I have a field where I want to insert a numerical value starting with two zeros and then numbers after. I have tried INT and VARCHAR and both eliminate the 00 in the front and give me the rest of the number when I insert them. Why is this?

Starting Auto_increment At Zero
Can an auto_increment field be started at 0? Javascript counts from 0 and I would like to not have to subtract 1 from the numbers I get out of my table. If anybody knows how to start things at zero that would be cool.

Starting MYSQL On A Mac
I feel quite stupid I cannot seem to get MYSQL to even run on my Mac (OS X 10.4)

I have installed MYSQL and then went to terminal and entered

cd /usr/local/mysql

then

sudo ./bin/mysqld_safe

then my password as prompted

which is followed by

Starting mysqld daemon with databases from /usr/local/mysql/data

- at this point as it just seems to stop

What next? I have tried entering mysql -u grifkerry -p but nothing happens! I have left it for a while but still nothing.

Starting MySQL
I need to transfer a database from one computer to another. Both computers are Macintoshes running OS X Panther. Both computers are running MySQL through localhost. The computer to which I am transferring the database has MySQL up and running perfectly fine.

The computer from which I want to get the database is able to query the database through a web application using Perl but when I try to run MySQL from the Unix command line using the following text: "mysql -h localhost -u root -p" I get the following response "-sh: mysql: command not found."

As far as I know, MySQL is installed correctly on this machine (I would assume it has to be in order for the web application to access the database through Perl and MySQL). If I can start and run MySQL, I know that I can dump the database using the "mysqldump" command. Does anyone have any suggestions on what I need to do to get the mysql command to execute correctly so that I can run the program?

Starting Mysql
im a complete novice regarding mysql

im am trying to start mysql with

c:
et start mysql

and get the system error 1067

Starting The Server
I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ...

Server could not be started." How can I start the instance or find out what's going wrong?

Starting Problem
I run Windows XP, Apache 2.0.54 (these are working fine), and have just installed MySQL 4.1. And i want to say I have the checked the included manual for clues, to why MySQL won't start on this machine. I get this error message when trying to start the server with:

C:ProgramMySQLMySQL Server 4.1in>mysqld --console
InnoDB: Error: log file .ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
050714 9:39:51 [ERROR] Can't init databases
050714 9:39:51 [ERROR] Aborting

050714 9:39:51 [Note] mysqld: Shutdown complete

----

Where do i find the .cnf-file that is mentioned?

Starting Mysql
I used to have an older version of Mysql (4.0) that I started by starting
Winmysqladmin. Now I replaced this with the newest version: 4.1.12 and that
doesn't have Winmysqladmin. After some experimentation I found out that
MYSQLD.EXE seems to start mysql. I can then use phpMyAdmin.

However, my own application still does not work (I can log in, but my
queries give no results). A possible explanation is that I selected the
UTF-8 fontset.

I would like to have advice of what causes this problem and how I can solve
this. I a using Windows ME.

Starting Up - Mysql_send.php
I've gotten to the point in the book where it tells me to configure mysql_send.php. It wants me to put in the host name, user name, and password.

Now, when I set up MySQL, I had the host as "localhost", and set up a simple username and password. I set this up on my desktop. My questions are:

1. Which host does this refer to - my computer or the server where my website is? Which is the correct entry?

2. Same question on the username and password - what is it referring to? website or my computer?

I started making tables of my data. I have a very basic idea of the fields, but when I complete a table, I get an error message when it executes the command to make the table. What is this about?

Starting Mysql
I am using window xp, I installed mysql 4.0 and it was working fine.
last week, I uninstalled mysql 4.0 and install 4.1 and it's no longer starting.

before, error message said, "mysql failed start, wait 30 then try again"
then I messed around with it. the error message is gone

right now, it doesn't start, it doesn't give me any error message and I can't even get mysql 4.0 working.

Mysql Not Starting
I had to reload mysql 4.0.17 on to a Fedora Core machine that was previously
working in the same configuration. Now though I can't get the server to run
with the either of the following commands:

../mysql.server start - the command line reappears with no error but no
running process in the system monitor
/usr/local/mysql/bin/mysqld_safe -user=mysql - this command does not return
to the command prompt so when I hit the enter key I get "Starting mysqld
daemon with databases from /var/lib/mysql 0404124 00:13:21 mysqld ended.

It looks to me as if it attempts to start but fails with no error. What am I
missing on the reinstall?

Autoincrement Starting Value
i am using PHPmyAdmin to manage the mySQL data base, i was wondering how to change the auto increment initial starting point.

if i want to generate an Auto number in Alpha Numeric, is there any sort of option in database ?

Starting Mysql
This may be a very simple question and possibly could have a very simple
solution to it.Since I have been using mysql for less than 2 months,I
still consider myself a newbie.I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
phpmyadmin.I have purchased MYSQL Second Edition (Paul Dubois) so I
hope to put it to good use soon.

The question that is of concern to me this morning is the prefered way
to start mysql.I seem to think that I always have a problem because
when I start my PC,mysql is already running as a service.But I am
thinking that because I login to my PC as any user other than the dbase
username,I have a problem afterwards.

Must I always log on to my PC (Win2K) as the same user as the created
user in my DBase in order for mysql to run properly?

Instance Not Re-Starting
I have a single instance of mysql running on my PC (Windows XP Prof.). I wanted to stop the service from running momentarily, and I did. However, now the service will not start even after rebooting and trying to start the instance manually.

Mysqldaemon Not Starting
I am this error while running mysqld_safe

# ./bin/mysqld_safe --user=mysql &
[1] 19413
# Starting mysqld daemon with databases from
/export/home/siptech/vidhya/ifmonitor/mysql/data
030728 12:17:49 mysqld ended

The daemon is not starting....

Starting MYSQL...
--=_5D034890.F392DE43
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie.... I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I
hope to put it to good use soon....

The question that is of concern to me this morning is the prefered way
to start mysql. I seem to think that I always have a problem because
when I start my PC, mysql is already running as a service. But I am
thinking that because I login to my PC as any user other than the dbase
username, I have a problem afterwards.

Must I always log on to my PC (Win2K) as the same user as the created
user in my DBase in order for mysql to run properly?

Starting Mysql 5.0.18
I type in the password and mysql closes. When I reinstall it as an anonymous user mysql asks me to type in my password. I've reinstalled the program a few times. I tried to reset the root password. None of these things work. I also saw that I have a file called prod.err. I open up the file and I see a bunch of stuff that I don't understand. I greatly appreciate anyone who could help me solve this problem. I've run out of ideas.

prod6.err:
InnoDB: The first specified data file .ibdata1 did not exist:
InnoDB: a new database to be created!
060215 16:31:56 InnoDB: Setting file .ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060215 16:31:56 InnoDB: Log file .ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060215 16:31:57 InnoDB: Log file .ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060215 16:31:57 InnoDB: Started; log sequence number 0 0
060215 16:31:58 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections.
Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
060215 16:52:38 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Normal shutdown

060215 16:52:39 InnoDB: Starting shutdown...
060215 16:52:40 InnoDB: Shutdown completed; log sequence number 0 43655
060215 16:52:40 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete

Starting Mysql
--=_81DF9BED.E485C8BC
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hello gang,

This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie.... I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I
hope to put it to good use soon....

The question that is of concern to me this morning is the prefered way
to start mysql. I seem to think that I always have a problem because
when I start my PC, mysql is already running as a service. But I am
thinking that because I login to my PC as any user other than the dbase
username, I have a problem afterwards.

Must I always log on to my PC (Win2K) as the same user as the created
user in my DBase in order for mysql to run properly?

Error On Starting
when i go to the command command prompt and change to the: c:program filesmysqlin folder and try to start mysqld --standalone i get an error. This is what im seeing:

C:Program FilesMySQLin>mysqld --standalone
050719 3:59:20 [ERROR] Can't find messagefile 'c:program filesmysqlmysql server 4.1shareenglisherrmsg.sys'
050719 3:59:20 [ERROR] Aborting

Now i see its trying to open errmsg.sys in the directory:
program filesmysqlmysql server 4.1shareenglish
but there's no "mysql server 4.1" folder because its all in the mysql folder. How can i fix this? Is there a way to let it search in the proper directory?

Auto_Increment Starting Value
For a table I'm creating, I want the auto_increment primary key to start at zero. I know that I can put auto_increment = <number> at the end of the query to make it start at that number, but it doesn't work for zero. Is there any way to make it do this?

I should probably mention something I already tried that didn't work. I tried creating the table and not making the column auto_increment. I added the first row with a value of zero, then changed the column to auto_increment, but unfortunately this automatically changed the value to a 1.

Starting Instance
I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ...
Server could not be started." How can I start the instance or find out what's going wrong?

Starting MySQL
I have a strange problem with mysql start. In normal procedure I do not see any problem.
I have my product patch (a tar file) and when I try to untar this under /tmp directory and try to start MySQL, it is not getting started. The tar file has following files extracted to /tmp folder
1. install
2. clearevents.sh
3. ClearEvents.class
4. README.txt
5. cleareventscron.txt

If I extract this tar file to some other folder, say /test, I do not see any problem in starting the SQL.Is there any conflict with the file names which I am using here?
Some one please help me in clarifying this issue.

Problem On Starting MySQL
Ubuntu-6.06-LAMP-server-amd64

I followed section "10 MySQL" on;
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4

and found "libmysqlclient12-dev" not installed. After installing it MySQL unabled to start. I reinstalled all packages recommended there.

$ sudo apt-get install --reinstall mysql-server mysql-client libmysqlclient12-dev
Password:

Reading package lists... Done
Building dependency tree... Done
0 upgraded, 0 newly installed, 3 reinstalled, 0 to remove and 8 not upgraded.
Need to get 0B/3305kB of archives.
After unpacking 0B of additional disk space will be used.
Do you want to continue [Y/n]?
(Reading database ... 82866 files and directories currently installed.)
Preparing to replace libmysqlclient12-dev 4.0.24-10ubuntu2 (using .../libmysqlclient12-dev_4.0.24-10ubuntu2_amd64.deb) ...
Unpacking replacement libmysqlclient12-dev ...
Preparing to replace mysql-client 5.0.22-0ubuntu6.06.2 (using .../mysql-client_5.0.22-0ubuntu6.06.2_all.deb) ...
Unpacking replacement mysql-client ...
Preparing to replace mysql-server 5.0.22-0ubuntu6.06.2 (using .../mysql-server_5.0.22-0ubuntu6.06.2_all.deb) ...
Unpacking replacement mysql-server ...
Setting up libmysqlclient12-dev (4.0.24-10ubuntu2) ...
Setting up mysql-client (5.0.22-0ubuntu6.06.2) ...
Setting up mysql-server (5.0.22-0ubuntu6.06.2) ...
$ sudo /etc/init.d/mysql restart

Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Please advise which file I have to edit getting the problem fixed. TIA

Create A Query Starting From A Value
I would like to know how to create a query which will return a certain number of rows from a database, starting from a particular key value. Something like

SELECT * FROM users STARTING FROM id=7 ORDER BY name LIMIT 5

Does something that does this exist?

I can't use WHERE id>7 because I am sorting on a different field and so the id field is unsorted.

Starting Query Browser
i installed mysql server 5.0 and other GUI components and the connector.in windows XP from the start menu i click my sql query browser and the dialogue box appears asking the host ,username and password and giving the port 3306(already filled in)i give localhost and the password which i gave during installation ,and an error comes saying mysql error 1045:access denied for user ODBC@localhost.

Mysql Server Not Starting
I installed mysql on a Mac OSX 1.3.9. It worked and ran with no problems. The machine was restarted and mysql will no longer start up. I have tried everything and nothing works. If I look at the logs it basically tells me that mysql starts and then shuts itself off.

Starting Mysql With Mysqld
i'm trying to change the mysql data path. to do this, i have to shoot down mysql and restart it. i tryed to restart mysql with the program mysqld (i'm using windows xp, mysql server 5.0), but it doesn't work. why? is there any different way to start mysql? there was no error message or something like this. if i start it with mysqld --standalone, it works, but the command window doesn't replay anymore.