If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > create script from old install of mysql

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-24-04, 09:14
w0rldd0m w0rldd0m is offline
Registered User
 
Join Date: Jan 2004
Posts: 12
create script from old install of mysql

Hi,

I have a linux server running mysql. recently a friend updated the version of mysql. In phpMyAdmin, the old db's aren't showing up. I believe they are still there but I need to fetch them in the form of a script that I can use later. I skimmed through the info on using 'mysql' from my terminal window. It is running so when I type mysql it starts to listen and assigns me an ID. I need a few things:
1. How can I fetch a list of all of the dbs?
2. How can I create a script file of each db with its structure and records?
3. Once this is complete, where should I look for the script file?

Thanks in advance for any help you can offer.

Best regards,

w0rldd0m
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On