Deleting databases in MYSQL problem asking... Post: 302392607

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL...

2. UNIX for Dummies Questions & Answers

Problem while Deleting file

All, I am trying to delete a user created file from specified folder. This folder is using for my Team member (i.e, Public folder). For example, $ ls -l total 1336 -rw-rw-r-- 1 g_btha customer 2655 Dec 06 12:35 A_COL_1001 While deleting/moving this file I am getting the following...

3. Shell Programming and Scripting

Mysql problem

No help guys??? :( Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file... so the first move would be, to access the mysql interface right? hence... #! /usr/bin/ksh echo "Job Begin: " `date` ...

4. UNIX for Dummies Questions & Answers

problem in deleting a file

Hello: I made this mistake on my tru64 machine, I renamed a file from: binary.errlog to binary.errlog(B3) now when im tryign to move or delete the file Im getting: # rm binary.errlog(B3) ksh: syntax error: `(' unexpected 4# mv binary.errlog(B3) log ksh: syntax error: `(' unexpected ...

5. UNIX for Dummies Questions & Answers

problem while deleting a file

Hi , In a particular path the below mentioned three files has been created. -rw-r--r-- 1 edwprod edw 0 Jun 5 00:06 -f%*lock.clock -rw-r--r-- 1 edwprod edw 151 Jun 5 00:06 -f.log -rw-r--r-- 1 edwprod edw 4 Jun 5 00:06 -f%conn_err.out ...

6. UNIX for Advanced & Expert Users

problem with deleting a file

hi friends, i need to delete a file named "-vyxx-.0.sdct.txt" i'm unable to use "rm -vyxx-.0.sdct.txt" jus give me your suggesstions thanks in advance

7. Web Development

deleting file created from mysql

Hi, I executed the query in mysql as "select * into outfile "/tmp/result.out" from table_x; which inturn wrote all the records in that table to file in /tmp directory.After this i tried to delete the file "/tmp/result.out", but can't able to do that. Is there any way to achieve...

8. Shell Programming and Scripting

Problem with deleting

Hi, I have a folder A which contains files 1,2,3... I also have a file xyz under a diff folder B containg the entries 1,2,3... I am trying to compare and delete the nonexisting ones from xyz using the below code: QFILE=/B/xyz cd A ls -1 > /tmp/file1 for fname in `cat $QFILE` do if ...

9. Shell Programming and Scripting

Problem in deleting files

Hi Guys, In one of my folders i have 10000 log files starting with sqlfile..... Iam trying to delete the log files alone from the folder using for loop but i am getting an error ksh: /usr/bin/ls: 0403-027 The parameter list is too long. For loop i used for i in `ls sqlfile*`...

10. Programming

MySQL Databases

Hello all again, How do you guys backup your MySQL databases? I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the...

LEARN ABOUT OPENSOLARIS

mysql_fix_privilege_tables

mysql(1)							  MySQL database							  mysql(1)

NAME

       mysql_fix_privilege_tables - Fixes MySQL privilege tables.

SYNOPSIS

       mysql_fix_privilege_tables [mysql_root_password]

DESCRIPTION

       This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above.

       This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

       If you get 'Access denied' errors, run the script again and give the MySQL root user password as an argument.

SEE ALSO

       isamchk(1),  isamlog(1),  mysql(1),  mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlshow(1),
       mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       This manpage was written by Christian Hammers <ch@debian.org>.

       MySQL is available at http://www.mysql.com/.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							   17 March 2003							  mysql(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

Discussion started by: _hp_

2. UNIX for Dummies Questions & Answers

Problem while Deleting file

Discussion started by: nvkuriseti

3. Shell Programming and Scripting

Mysql problem

Discussion started by: 12yearold

4. UNIX for Dummies Questions & Answers

problem in deleting a file

Discussion started by: aladdin