By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

I have MySQL tables in notepad, how can i put them in MySQL database server

P: 8
I have MySQL tables in Ms. Notepad, how can i put them in MySQL Server and want to extract all the required information from these tables to make an excelsheet.please give the answer in a detailed way so that i can implement the same. Please reply anybody to my ID saajgow@yahoo.com.

Thanks & regards
Sajad H Bhat
Apr 4 '11 #1
Share this Question
Share on Google+
1 Reply


dgreenhouse
Expert 100+
P: 250
Are you saying that you have the table creation and data insertion statements in a text file?

If you have phpMyAdmin installed, you could use that.

If not, you could possibly create a program to execute the creation/data insertion stuff.

If not that, then you'd need access ssh on linux or the cli on windows.

Give an example of the contents of the file.
NOT THE WHOLE FILE - PLEASE! :)

Also let us know if you have phpMyAdmin installed and your level of computer expertise in general.
Apr 6 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.