How to use the mysqldump command - a working example

[eliramb]

Thanks!

[rb3883]

thank fuck for that, i did it!!!!!!!!! thx a lot mate

[Superman1GTR]

Thanx!!! :) username "root" works perfectly

[chalusan]

any solutiion ?

[chalusan]

ok sir..very thanks and very appreciable..im waiting for your reply..rest, im trying on my side..

[chalusan]

ok then tell me ..how to install/remove mysql on any sever..when we are logging on one ip through putty

[Ranginald]

@chalusan That's a tall order for this small comment area. I'd do a google search for that and find some good step-by-step instructions.

[chalusan]

im done with this sir...thanks very much..thanks alot.sir..please help me in one more solution..

c i need to install one instance of mysql, parallel with the existing one..i need to install it remotely..and both versions are different..and platform is unix...please tell me..how to do it...im waiting for your reply..im logging on ip through ssh only (putty)

[Ranginald]

@chalusan I'm not sure about this one. I don't know if you can run two instances of mysql on the same box. Though I'm sure you COULD do it, I'm not too sure if that's such a good idea....

[chalusan]

access denied for user odbc@localhost (using password = no) when trying to connect

this is the error im having

[Ranginald]

@chalusan tough call. try to login as root and with no password and see if it works.

[chalusan]

please tell me sir..what is username and password as my db has no username and password...

[Ranginald]

@chalusan try "root" as the username with no password (and don't put quotes for root).

[xmoves]

Thank you very much! You may also want to add "-h host_name" after password when you are using external host. Example:

mysqldump -u dbuser -p -h hostname dbname > filename.sql

[Ranginald]

make sure you are witih mysql. if you want you can change your windows path, just find the mysqldump.exe command and either navigate to that path or set the windows path to that file location. But don't mess with the path file unless you know what you are doing and make sure you copy the path file before you edit it just in case something gets screwy.

[tqbfjotldtqbfjotld]

Hi, thx for your concise explanation, but when I open command prompt on my windows 7 and type in mysqldump, it gives me this message: 'mysqldump' is not recognized as an internal or external command, operable program or batch file.

Plz help!

[Ranginald]

what do you mean import from source? from a .sql file?

[TheAjeet123]

can you tell me plz that how can i import a database from source file to mysql

[ZeKalanga92]

thank you very much.

[Ranginald]

you're welcome. and it should. I'd run the dump and then you can open the .sql file in any text editor to see if your db objects are recreated. easy to check.. and please post back to let everyone else know.

[XITIJTHOOL]

Thank you for best explanation. So does it includes all the database objects like views ,triggers and others things right ?

[Ranginald]

@kavindasilva2005 do you have the right privileges?

[pencilking2002]

Thank god! I spent all day putting this command in the mysql command line client, but this cleared things up!!! 

[auyou01]

Thanks, I found it very helpful ;)

[voltinsky]

You are a very good teacher, very clear and simple, thank you

[computerjantje]

Thankyou very much. A very clear explaining with exactly the added extra remarks I needed to be able to understand what I was doing. Or better said: "trying to do" before I found your tutorial.

Thanks :)

[classicallife]

thanks so much you really helped me

[Ranginald]

No problem. If you have any other questions let me know. I'm always looking for ideas for new video tutorials so ask away if needed...

[santiagoarias550]

this tutorial is great! Thank you so much!

[skidooboy105]

what?????????