Jump to content

Export

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
Guest_NeedHelp_*

Guest_NeedHelp_*
  • Guests
How can I export my entire MySQL database to a flat file so that I can import it in another MySQL database? I only have access to the shell MySQL (no phpMyAdmin).

Any help?

#2
dirkfirst

dirkfirst

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 354 posts
There is a shell script [Here] that does it, just take the code from it.

#3
Lop

Lop

    Speaks fluent binary

  • Members
  • PipPipPipPipPipPipPipPip
  • 1,172 posts
Very easy to do. Just take the contents of that shell script and you got it!

#4
Void

Void

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 411 posts
Very easy:

mysqldump Databasename –p > FileToSendDatato.SQL
Void