Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
mysql dump. So, I
Alla-amin wrote:
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up, so i think it
was
Alla-amin wrote:
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up,
I have to ask, are you using the same version of MySQL? I think 10.1
came with v3 and 10.3 come with v4.0.
You may need to setup 10.1.5 on an old machine to dump the database for
importing.
On Jun 23, 2005, at 4:53 PM, Alla-amin wrote:
Hi everyone,
I just subscribed to the list and some
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy these files to the the
Alla-amin wrote:
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy
You can't transfer database files directly between versions. The file
format is different. You need to dump the data to a text file and
import it.
This isn't like FileMaker, Word or Excel where it will realize it's an
older version and convert it.
On Jun 24, 2005, at 9:42 AM, Alla-amin
Hello.
What is in MySQL error log? Did you use InnoDB tables?
Alla-amin [EMAIL PROTECTED] wrote:
Hi everyone,
I just subscribed to the list and some of the articles
are very helpful. I'm facing some problem on my mysql
database server.
One of our Raid drives crashed and
Hi everyone,
I just subscribed to the list and some of the articles
are very helpful. I'm facing some problem on my mysql
database server.
One of our Raid drives crashed and we had to backup
the whole data to another drive (only files), we did
no mysqldump. Now I want to restore a certain
10 matches
Mail list logo