Thanks, it works! But I have been failure dumping csv / tab delimited file using $ mysqldump -T ~/public_html u_fuzkabir University; results
mysqldump: Got error: 1045: Access denied for user 'fuzkabir'@'%.toolserver.org'(using password: YES) when executing 'SELECT INTO OUTFILE' previously i also tried using SELECT * from table INTO OUTFILE "path" both in phpmyadmin & mysql command prompt another thing is while i export csv from phpmyadmin the download limit to approx 11MB. may be for security reasons. plz suggest me a solution. --- On Sun, 10/4/09, Jeff Ferland <[email protected]> wrote: From: Jeff Ferland <[email protected]> Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html To: [email protected] Date: Sunday, October 4, 2009, 6:04 PM Skip the username and password part too. On the toolserver, mysqldump should be pulling your username & password from the config file. Specify the host (as by default, it won't connect to the local machine which is running no db). The standard format is listing the database as an argument, then all tables as following arguments. $ mysqldump -h sql u_fuzkabir university > ~/public_html/university.sql That was verified with my own table / db names. -Jeff On Oct 4, 2009, at 1:57 PM, Platonides wrote: > Tim Alder wrote: >> Hello, >> try "/home/fuzkabir/public_html" instead of >> "/$home/fuzkabir/public_html" . >> >> What works for me is: >> mysqldump u_kolossos_databaseX tableXXX > XXX.sql >> >> Greetings Kolossos >> >>>> mysqldump u- username -p password `u_fuzkabir`.`university` > / >>>> $home/fuzkabir/public_html; >>>> > > > and those ` would be interpreted by the shell. > > Try mysqldump -u username -p password '`u_fuzkabir`.`university`' > > /$HOME/public_html/university.sql > > _______________________________________________ > Toolserver-l mailing list ([email protected]) > https://lists.wikimedia.org/mailman/listinfo/toolserver-l > Posting guidelines for this list: > https://wiki.toolserver.org/view/Mailing_list_etiquette _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
_______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
