mysql table disappear

Special Forums UNIX and Linux Applications mysql table disappear

01-22-2011

Registered User

1, 0

Join Date: Jan 2011

Last Activity: 22 January 2011, 10:44 PM EST

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

mysql table disappear

I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening? Otherwise I have to create the tables manually everyday....

Thanks.

c203040

View Public Profile for c203040

Find all posts by c203040

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Send Data to MySQL Table Columns

I have two scripts, each script reads an individual data file and copies specific lines of data and sends to MySQL table. Only difference is, each script sends data to a separate column on the same DB. I want to use one script to populate DB table and have data look horizontal, with no overlapping....

2. Web Development

Mysql table is marked as crashed and should be repaired

140312 13:43:54 /usr/libexec/mysqld: Table './***/phpbb_posts' is marked as crashed and should be repaired Its mysqld.log in var/log alot of messages, but before around hour i tried to "repaid table" from within phpmyadmin, but appears it has no effect.. why? How to fix?

3. Web Development

MYSQL: Creating Dynamic Table Names 5.1

Hey everyone. Thanks for looking at this. I'm trying to create a table with the dynamic name of TableName + today's date. My variables are all happily created but the system chokes when I try to create the new table name example: Set @BFBW = CONCAT("BFBW", CURDATE()); Select @BFBW; ...

4. Shell Programming and Scripting

mysql how to select a specific row from a table

5. Homework & Coursework Questions

Displaying text from a MySQL table which can be modified

Hi am creating a website for my third year at uni, am trying to create a website where the client can update the content of the site themselves, i will have a news page and i want the content to be draw from my database and displayed on the front end of the site using php, i also want to have an...

6. Shell Programming and Scripting

Compare file of hostnames with table in MySQL DB

Hi all, i have a list of files that contains some PC hostname, then i need to enumerate every hostname and check if there's a table with same name of the hosts in MySQL database XYZ. I need this because have to decide automatically if i have to make a create table or a insert into an existent...

7. Programming

API C MYSQL vs lock table ???

(sorry for my english) Hi, i have an app that uses MYSQL API C.. i trying do a timeout until the table is locked by an other thread , in the docs of Mysql i can see that MYSQL_OPT_READ_TIMEOUT is not implemented for linux �?�?.. any body knows a way to do a timeout until the table is locked by...

8. Shell Programming and Scripting

Help Inserting data in mysql table

Cant understand the error #!/bin/bash temp="" A="" D=$(date +"%Y-%m-%d") H=$(date +"%R") temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+") mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)"; my data types for...

9. UNIX for Dummies Questions & Answers

Editing a mySQL table on a remote machine

Hi all, My problem: I want to connect to a remote computer (in the same office as me) which is running a mySQL server, access a specific table and update it, beofre disconnecting from the server. Is this possible? If so, any links/tutorials which might be of use? I had thought of some sort of...

10. Shell Programming and Scripting

MySql: create table error

Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook" at the command line in mysql heres what i type but i get a error mysql>create table guestbook ->( -> name varchar(40) null. -> url varchar(40) null. -> comments ...

LEARN ABOUT OPENSOLARIS

mysqlaccess

mysqlaccess(1)							  MySQL database						    mysqlaccess(1)

NAME

       mysqlaccess-Createnewuserstomysql.

USAGE

       mysqlaccess [host [user [db]]] OPTIONS

SYNOPSIS

       mysqlaccess  [-?|--help]  [-v|--version]  [-p|--password=#]  [-h|--host=#] [-d|--db=#] [-U|--superuser=#] [-P|--spassword=#] [-H|--rhost=#]
       [--old_server] [-b|--brief] [-t|--table] [--relnotes] [--plan] [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]

DESCRIPTION

       -?|--help
	      display this helpscreen and exit

       -v|--version
	      print information on the program `mysqlaccess'

       -u|--user=#
	      username for logging in to the db

       -p|--password=#
	      validate password for user

       -h|--host=#
	      name or IP-number of the host

       -d|--db=#
	      name of the database

       -U|--superuser=#
	      connect as superuser

       -P|--spassword=#
	      password for superuser

       -H|--rhost=#
	      remote MySQL-server to connect to

       --old_server
	      connect to old MySQL-server (before v3.21) which does not yet know how to handle full where clauses.

       -b|--brief
	      single-line tabular report

       -t|--table
	      report in table-format

       --relnotes
	      print release-notes

       --plan print suggestions/ideas for future releases

       --howto
	      some examples of how to run `mysqlaccess'

       --debug=N
	      enter debuglevel N (0..3)

       --copy reload temporary grant-tables from original ones

       --preview
	      show differences in privileges after making changes in (temporary) grant-tables

       --commit
	      copy grant-rules from temporary tables to grant-tables (!don't forget to do an mysqladmin reload)

       --rollback
	      undo the last changes to the grant-tables.

NOTE

       At least the user and the db must be given (even with wildcards) If no host is  given,  `localhost'  is	assumed  Wildcards  (*,?,%,_)  are
       allowed for host, user and db, but be sure to escape them from your shell!! (i.e., type * or '*')

SEE ALSO

       isamchk(1),  isamlog(1),  mysql(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(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

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.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							 19 December 2000						    mysqlaccess(1)

UNIX and Linux Applications