•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,954 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,230 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 1819 | Replies: 5
 |
•
•
Join Date: Jan 2007
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
MySql file HI, I'm still rookie guy with mysql database, I have a mysql script file called "MYBox" in notepad and I want to export to the one of folder directory but I don't know to do that from Does.
I need someone help me what command do I need to type in does to export Mybox file please.
Thanks.
AM
I need someone help me what command do I need to type in does to export Mybox file please.
Thanks.
AM
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,222
Reputation:
Rep Power: 10
Solved Threads: 270
if that file actualy create table and than insert some vulues you can simple run command prompt
then it will ask you for db password
mysql -u user_name database_name<your_textfile+extension -p
so it can look like this
mysql -u root dvdDatabase<myDvds.sql -p Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Jan 2007
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
thank you for your help, please correct me if I'm wrong, the file that i have is called domes.txt and to make new database by run execute file by going to
mysql> -u Username domes<domes.sql -p
is this is correct! if so then why i did not showing on the database list!
please help!
AM
mysql> -u Username domes<domes.sql -p
is this is correct! if so then why i did not showing on the database list!
please help!
AM
•
•
•
•
Originally Posted by peter_budo 
if that file actualy create table and than insert some vulues you can simple run command prompt
then it will ask you for db passwordmysql -u user_name database_name<your_textfile+extension -p so it can look like this mysql -u root dvdDatabase<myDvds.sql -p
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,222
Reputation:
Rep Power: 10
Solved Threads: 270
- database to which you want to import your tables must exist, if not create it
- for import/export I do not use MySQL command prompt Client but Windows Command Prompt, that is why there are options(-u for user, -p for password), my mistake I should mention it. When importing make shore that you are in the same directory as the file which you want to import into database as typing full path is usualy problematic( plenty of spelling mistakes), so use cd.. to move out of current folder, dir to list content of folder and cd my_folder/sub_folder to enter into a folder
if you still have problem let me know
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Jan 2007
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Peter;
thanks for your response, when you said you do not use command prompt but window command, i think that must be easier to use. can you let me know which program from window command to use!
please correct me if I'm wrong.
1) the first step is that to create empty database called "domes"
2) then run execute .txt file of "domes.txt" and will convert to the sql in new database of "domes.sql"
Is this is correct step what I'm suppose to do!
Is that possible for me to send you small txt file sql script and you can take look for few minutes then you might have better idea of what you think i should do better way.
please let me know thanks.
Alidad
thanks for your response, when you said you do not use command prompt but window command, i think that must be easier to use. can you let me know which program from window command to use!
please correct me if I'm wrong.
1) the first step is that to create empty database called "domes"
2) then run execute .txt file of "domes.txt" and will convert to the sql in new database of "domes.sql"
Is this is correct step what I'm suppose to do!
Is that possible for me to send you small txt file sql script and you can take look for few minutes then you might have better idea of what you think i should do better way.
please let me know thanks.
Alidad
•
•
•
•
Originally Posted by peter_budo
if you still have problem let me know
- database to which you want to import your tables must exist, if not create it
- for import/export I do not use MySQL command prompt Client but Windows Command Prompt, that is why there are options(-u for user, -p for password), my mistake I should mention it. When importing make shore that you are in the same directory as the file which you want to import into database as typing full path is usualy problematic( plenty of spelling mistakes), so use cd.. to move out of current folder, dir to list content of folder and cd my_folder/sub_folder to enter into a folder
•
•
Join Date: Jan 2007
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Peter;
thanks for your response, when you said you do not use command prompt but window command, i think that must be easier to use. can you let me know which program from window command to use!
please correct me if I'm wrong.
1) the first step is that to create empty database called "domes"
2) then run execute .txt file of "domes.txt" and will convert to the sql in new database of "domes.sql"
Is this is correct step what I'm suppose to do!
Is that possible for me to send you small txt file sql script and you can take look for few minutes then you might have better idea of what you think i should do better way.
please let me know thanks.
AM
thanks for your response, when you said you do not use command prompt but window command, i think that must be easier to use. can you let me know which program from window command to use!
please correct me if I'm wrong.
1) the first step is that to create empty database called "domes"
2) then run execute .txt file of "domes.txt" and will convert to the sql in new database of "domes.sql"
Is this is correct step what I'm suppose to do!
Is that possible for me to send you small txt file sql script and you can take look for few minutes then you might have better idea of what you think i should do better way.
please let me know thanks.
AM
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Upload Database (MySQL)
- all program extensions are now replaced with one .lnk (Windows NT / 2000 / XP / 2003)
- Beginner.........Books (MySQL)
- Import/export tab delimited file (PHP)
Other Threads in the MySQL Forum
- Previous Thread: Database Storage Capacity
- Next Thread: Get Auto Incremented Value
