Backup DB
HI All I am new to mysql. We have a small application which runs on mysql db. We want to backup the database for mysql. What is the easiest method to that ? Do we have to move datafiles or import export like oracle ? If you can send me a specific link or article for backup and recovery for mysql , I'll be very much thankful. Thanks Amol Oracle 8i DBA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error-1044
Hi All I have a database named "bugs" on server and and a user assigned for it named "bugs" only. This database is used for Bugzilla database and till today it was running fine. However there were some changes done by system administrator and then the connectivity from the application stopped. I am connecting from root user to the server and if I issue a command # mysql -D bugs -u bugs@localhost It gives the error "Access denied for the user bugs@localhost" (Error - 1044) However If I issue the command #mysql -D bugs -u bugs Then it connects to the bugs database using user bugs. However my Application scripts which contains "bugs@localhost" at many places, which cannot be changed. In short I would like to connect to bugs database using "bugs@localhost" how I should do that ??? The sys admin don't know what exactly he has done .. I have seen the tables in "mysql" database namely "user" and "db" which stores the database settings. In both the the "HOST" column is set to "localhost" value. Can you please help me out. Thanks in Advance Amol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to connect to mysql databases
There is still error I did as per your say at mysql> use test; but the error it gave was ERROR 1044: Access denied for user: '@localhost' to database 'test' even if I do something like this mysql> mysql -u amol test -p ERROR 1045: Access denied for user: 'amol@localhost' (Using password: YES)"This result we get ". What can be way out. Is there any suggestions. Amol On Thu, 21 Mar 2002 16:35:56 -0800 "Sherwin T. Ang" <[EMAIL PROTECTED]> wrote: >to connect to a certain database type in, > >mysql> use databasename; >where databasename is the name of your database. > >or you can specify the database in the command line like: > >mysql -uroot databasename -p >where root is the user and databasename is the database to >use/connect to. > >Hope that helps =) > > >Regards, > >Sherwin T. Ang >Web Technical Administrator / Programmer >Alchemy Solutions >http://www.alchemy.com.ph >Creative. Technology. > >Tridel Technologies, Inc. >7th Floor Hanston Building >Emerald Ave., Ortigas Center >Pasig City >Philippines > >Tel: (632) 634-5141/ (632) 634-5140 Local 1040 >Fax: (632) 634-5139 >- Original Message - >From: "amol sonaikar" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, March 21, 2002 12:17 AM >Subject: How to connect to mysql databases > > >> Hi all . I am on a Linux 6.2 client and accessing MySql directly on >> the server. I have connected to server using Telnet. I am at mysql> >> prompt >> and when I say show databases ; it showing me the databases over >> there. However how can I connect to these databases. I used connect >> comand but it's not working >> >> Amol >> - >> http://mail.indiainfo.com >> India's first ISO certified portal >> Check world time at http://time.indiainfo.com >> >> - >> Before posting, please check: >>http://www.mysql.com/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail ><[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: >>http://lists.mysql.com/php/unsubscribe.php >> >> > > - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to connect to mysql databases
Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql> prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New to mysql .. how to start it
Hi All I am very much new to mysql. We have installed it in machine but I don't know how to start it and what's it's default user to connect. I am still stuck at $ prompt..entering command Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
