 | | | MySQL on Win32 | | Hi Mark
I think you exported db when Innodb enabled. So you follow the steps to
avoid losing the db datas.
1. back the data folder for safer side. ( before take backup stop the mysql
service)
2. conHi
I used mysqlbackup to backup and old database (4.x) i
now need to restore this but i 'm using mysql 5.0
when i run the mysql < db.sql it wont work anybody
come accross this ?
thanks
Mark
Hi
I created a new library to be linked with mysqld.exe. My code has the
following include files
#include "mysql_priv.h "
#include <sys/types.h >
#include <sys/stat.h >
#include "my_dir.h "
#includeHi
Yes it will work no worries but make sure you should stopped mysql service
when you copy the old data to new place.
1. Stop the mysql service
2. take the backup of old data folder
3. stop the sHello
Please correct me if I 'm wrong.
We previously had a mySQL server installed on the default C Drive.
We have now upgraded to a new box with a faster processor new drives
etc. I have taken thYou can also use --skip-column-names to make the output a little
cleaner.
Peace
Scott
-----Original Message-----
From Bonnett John [mailto John.Bonnett@(protected)]
Sent Friday September Haven 't done this one wihtMySQL yet but my feeling is that anything
belongs off the root if it is to be generally shared across users.
I believe the same is true of documents folders that will be sh
What is the best way to install MySQL on Vista?
I 'm assuming the expected location is under Program Files like any other
program. But since Vista won 't let any program write to the program files
diThanks. I figured out that I could also loop over subfolders in the MySQL
data directory to give me each of the database names.
----- Original Message -----
From "Bonnett John " <John.Bonnett@(protected)Something like
mysql -u root -p --execute "SHOW Databases " mysql
Should get you what you want. There may be some other options to give
you the output in a form and place that suits you.
John BonnetI guess I would check operating system versions etc. and if it is up to
date with patches. There are different versions of the Windows installer
and you might need a later one.
John Bonnett
-----OriWe use a simple batch file for backups that does a mysqldump on each
database on our MySQL 5.0 server. When we create a new database on the
server though we need to modify the batch file which iCheck the MySQL manual
2.9.2.3. Starting and Troubleshooting the MySQL Server
And
2.3.13. Troubleshooting a MySQL Installation Under Windows
You can run the MySQL server by running the program mysqlAfter choosing which type of install I want for MySQL 4.1 I receive Internal Error 2275. 1601 D \Scrapd\setup\jpegger\mysql-essential-4.1.22-win32.msi
I have never received this error before and ICheck the contents of you my.cnf. look in the C \ and %windir% folders.
-----Original Message-----
From Jorge Bastos [mailto mysql.jorge@(protected)]
Sent Wednesday September 05 2007 12 36 PM
TWhat does say the event viewer?
----- Original Message -----
From "Steven Durant-Burgin " <stevendurantburgin@(protected) >
To <win32@(protected) >
Sent Wednesday September 05 2007 4 20 I have run the MySQL Server Instance Configuration Wizard and used all of
the default settings when I get to the ?execute? part I get an error
message ?Could not start the service MySQL. Error 0? wheHi All
Is it essential to lock tables when optimizing them?
I have a scheduled task which loops over all of my tables and optimises
them but it seems to be causing some problems. I notice that in tHi Lenz
After I sent out the message on "Missing files in Windows source
distribution " I noticed a change in MySQL online document at page
<http //dev.mysql.com/doc/refman/5.0/en/windows-source---8323584-1834330795-1188425490 31090
Content-Type TEXT/PLAIN charset UTF-8
Content-Transfer-Encoding QUOTED-PRINTABLE
-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
On Wed 15 Aug 2007 RonHi Mark
Shawn reply is right way... but its bit difficult to recover...
I was faced the same problem when I was trying to install Linux My OS
corrupted so I found the way just install the windows 2Others may be able to advise you better but assuming your MySQL data
folder is intact I would just copy that safely somewhere else install
the same version of MySQL then copy the contents of the sAt 08 35 AM 8/27/2007 Mark Mchugh wrote
>i had 2 partitions on it before i can see all the
>files now but the 2003 partition cant boot and never
>will.... i can see the old data folders + files etOOPS!! I made a typo!!
Shawn Green wrote
> <snip >
> Well you are in a totally different situation than I thought you
> were! Yes your database should be intact. In fact you may be able to
> useMark Mchugh wrote
> i had 2 partitions on it before i can see all the
> files now but the 2003 partition cant boot and never
> will.... i can see the old data folders + files etc
> but i presume ii had 2 partitions on it before i can see all the
files now but the 2003 partition cant boot and never
will.... i can see the old data folders + files etc
but i presume i can just copy these over tMark Mchugh wrote
> Hi
> A strange one here my windows 2003 server died but i
> have managed to get access to all the drive i had
> mysql 5.0 installed on it. The issue was caused by
> incompatibHi
A strange one here my windows 2003 server died but i
have managed to get access to all the drive i had
mysql 5.0 installed on it. The issue was caused by
incompatible hardware so 2003 will nothi if anybody wants to reach me please try this account - james.benjamin@(protected) <JAMES dot BENJAMIN at GRAFFITI dot NET > or call me on 0044 750 408 9783
Weather Almanac Weather Folklore BooksHello
Here 's 4 easy steps that show how you too can be a "Seriously
Disruptive " DBA
1) Sign on to MySQL as "root "
2) Perform a "show databases "
3) For each entry you see issue a "drop databa |
|
|
