Hi,
After our server 'wiped out' adversity by someone, we re-installed all the necessary mysql files.
I am trying to separate my working database folder from the mysql program folder, and I want mysql to point my working database when it is invoked instead of the installed program folder where all lib, include, bin, etc are living. Can anybody help me on this issue? Thanks!
10  1556 
Hi,
After our server 'wiped out' adversity by someone, we re-installed all the necessary mysql files.
I am trying to separate my working database folder from the mysql program folder, and I want mysql to point my working database when it is invoked instead of the installed program folder where all lib, include, bin, etc are living. Can anybody help me on this issue? Thanks!
I figured it out.
I made the change in my.ini!
Thanks!
Thanks. However, nobody provided a solution yet. See you again next time.
Ronald
Thanks. However, nobody provided a solution yet. See you again next time.
Ronald
Hi,
I am facing even more serious problem after this adversity.
My database was built in MySQL 4.1, but the version 5 was installed by admin people. Somehow mysql program is not recognizing all the tables in my db which I copied into a new folder (Window XP! by the way) from my thurm drive. It shows all the tables' name at the command "show tables" but says "xxx table does not exist" when you do select command. I know that I have data in the tables. Can anyone help me...?
Is this problem due to the new version of mysql ?
Have you done a db dump in MySQL 4? If so, the you can (e.g. using phpMyAdmin in MySQL 5) import that backup into your new database.
If not, are you still able to go to MySQL 4 and do this dump?
Ronald
Have you done a db dump in MySQL 4? If so, the you can (e.g. using phpMyAdmin in MySQL 5) import that backup into your new database.
If not, are you still able to go to MySQL 4 and do this dump?
Ronald
Hi,
Sorry for the delay, but I just returned to my office.
Are you saying that I should downgrade mysql to 4 from 5 and try to open the db?
Hi,
Sorry for the delay, but I just returned to my office.
Are you saying that I should downgrade mysql to 4 from 5 and try to open the db?
Hi Ronald,
When I realized, after our admin people wiped out my server, that I kept the database I created on my thum, I was so glad and didn't worry anything else. Now I found out that the newer version, mysql 5, cannot open the tables, I am very frustrated.
I was ignorant, not knowing that just copying those table files from my PC onto my thum was not copying my tables which contained all the data and dynamic headings. Is it true?
One of the tables has more than 70 columns and it is not easy to recreate all the tables. Can you think of any other way to recover my tables? Maybe the term, recover, is not appropriate since I had copied them onto my thum.
I am afraid I cannot be of much help here. Also, I cannot find anything in the MySQL documentation to handle this problem.
The only thing I could find was this post about importing *.frm, *.MYD, *.MYI import to MySQL table
Hope it helps you. Good luck!
Ronald
I am afraid I cannot be of much help here. Also, I cannot find anything in the MySQL documentation to handle this problem.
The only thing I could find was this post about importing *.frm, *.MYD, *.MYI import to MySQL table
Hope it helps you. Good luck!
Ronald
Hi Ronald and Everyone!
I was able to find the solution and I'd like to share the information with someone who happen to have the same problem.
Restroing MySQL InnoDB Files on Windows:
by Nerdy Dork
The link is: http://www.nerdydork.com/restroing-m...n-windows.html
Hope this can help someone who is pulling her/his hair like me yesterday!
Thanks for your help, Ronald!
Thanks very much for sharing this with our members.
Hope to see you around some time.
Ronald
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Craig Bailey |
last post by:
Anyone recommend a good script editor for Mac OS X?
Just finished a 4-day PHP class in front of a Windows machine, and liked
the editor we used. Don't recall the name, but it gave line numbers as...
|
by: Chris |
last post by:
Sorry to post so much code all at once but I'm banging my head against
the wall trying to get this to work!
Does anyone have any idea where I'm going wrong?
Thanks in advance and sorry again...
|
by: Alan Walkington |
last post by:
Folks:
How can I get an /exec'ed/ process to run in the background on an XP box?
I have a monitor-like process which I am starting as
'exec("something.exe");' and, of course the exec function...
|
by: John Ryan |
last post by:
What PHP code would I use to check if submitted sites to my directory
actually exist?? I want to use something that can return the server
code to me, ie HTTP 300 OK, or whatever. Can I do this with...
|
by: James |
last post by:
What is the best method for creating a Web Page that uses both
PHP and HTML ?
<HTML>
BLA
BLA
BLA
BLA
BLA
|
by: Topspin |
last post by:
I'm running PHP on Windows, but that's just the local test... in production
it will be on Apache.
I am not using PHP as a CGI. I want to perform redirection of the user's
browser if the user...
|
by: sky2070 |
last post by:
i have two file with jobapp.html calling jobapp_action.php
<HTML>
<!-- jobapp.html -->
<BODY>
<H1>Phop's Bicycles Job Application</H1>
<P>Are you looking for an exciting career in the world of...
|
by: Brian |
last post by:
I have an array like this:
$events = array(
array(
'2003-07-01',
'Event Title 1',
'1' //ID Number (not unique)
),
array(
'2003-07-02',
|
by: Clarice Almeida Hughes |
last post by:
tenho um index onde tenho o link pro arq css, como sao visualizados pelo
include todas as paginas aderem ao css linkado no index. so q eu preciso de
alguns links com outras cores no css, o q devo...
|
by: JW |
last post by:
I wanted have this as part of a flood control script:
<?
echo ("Flood control in place - please wait " . $floodinterval . " seconds
between postings.");
sleep(5);
// go back two pages
echo...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
