Ubuntu Servers :: [MySQL] Where To Create A New Table

Jul 13, 2011

I've started a webserver at**** I want to be able to use a database for this server. Which schema do I use to add a new table to? Do I create a new Schema altogether?

View 5 Replies


Software :: Mysql 5.0 - What Is The Use Of UNION=() In CREATE TABLE

Feb 24, 2009

What is the use of UNION=() in CREATE TABLE?



I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing[URL]. It only explains using UNION in a SELECT statement which I understand. If I drop off UNION=() then CREATE TABLE works fine.

View 4 Replies View Related

Ubuntu Servers :: Import Table.sql To Mysql?

Jun 8, 2011

I am trying to install some program: rosinfo: - Create mysql database for rosinfo - Create table hosts, locks. Use file docs/rosinfo.sqlAnd I need to create table hosts, locks, using file rosinfo.sql. I have that file, but dont know what to do with it.

View 1 Replies View Related

Ubuntu Servers :: Trying To Insert JPG File Into MySQL Table

Mar 12, 2011

I would like to store JPG files in a mysql database table. I figured that using BLOB fields on the one hand and the 'load_file' command on the other would do the trick. Here is how I set up the table:

mysql> create table blobtable (id int(10) not null auto_increment,
fileName varchar(15) not null,
file longblob not null, primary key(id) );
Query OK, 0 rows affected (0.51 sec)

Then I tried to enter the data:
mysql> insert into blobtable(filename,file)values('pic',load_file('/var/www/temp/IMGP4764.JPG'));

Which got me the following error signal:
ERROR 1048 (23000): Column 'file' cannot be null

It seems to me that the file path to the JPG file (although correct) is the source of the problem, and is causing the load_file command not to work. My first attempt was with the JPG file in my PC's home directory. When that returned the same error message, I figured that maybe the file had to be in the PC's (server's) web area so I put it under the 'www' directory.

View 7 Replies View Related

Ubuntu Servers :: Trace Origin Of Mysql Table Check?

Sep 27, 2010

I have a mysql server which "goes down" every day at 9, because the debian-sys-maint user needs to run a table check, for no particular reason.

I assume it's a cron-job, but I can't find anything related to this. There's the mysqlautobackup script, but that runs at 4 in the morning, which is expected and perfectly acceptable.

View 1 Replies View Related

OpenSUSE :: Kmail Akonadi And Mysql Errors - Can't Open And Lock Time Zone Table: Table

May 3, 2010

Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:

100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled.
100503 10:00:15 InnoDB: Started; log sequence number 0 31413862
100503 10:00:15 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without


View 2 Replies View Related

Ubuntu Servers :: Create More Than One Mysql Instance?

Dec 28, 2010

Hi. I need to create second mysql instance on the same server but another port. What is the right way to do that?

View 1 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run

GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:


View 13 Replies View Related

Ubuntu Installation :: Create New Partition Table Does Automatically Create New Mbr

Oct 28, 2010

When using the gparted option to create a new partition table does this automatically create a new mbr?

View 1 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

Server :: Replicate 1 Table In Mysql To Different IP?

Aug 7, 2009

I have 2 servers, 1 running a web server on 1 IP address,the other server running a proxy on a different IP address. I intend to change and update the ncsa file with usernames and passwords from a mysql table.Is there a way to replicate 1 table from the webserver to the proxy server databases and then run a cronjob? The cron will simply delete unused usernames and add new ones.Is there a better way of doing this? I don't want to run the webserver on the proxy server for security and also for performance.

View 2 Replies View Related

Programming :: PHP Ignores One MySQL Table But Not Others?

Sep 23, 2010

I have just run into a baffling error. I have a database set up in MySQL with six tables. My PHP based website performs queries of all kinds on these tables (SELECT, INSERT, UPDATE, DELETE). On my most recently setup table, the "Orders" table, I am able to perform queries from the server, as well as from my PHP MySQL Admin interface, but all activity from my webpage states that the Orders table does not exist. All other tables are running fine. I have tried rewriting the query script, checked for case sensitivity problems, even cut and pasted other working scripts in place, changing the table and field names as needed. No success. What could cause a single table to not show up like this?

View 2 Replies View Related

Ubuntu :: Simply Edit Table Data For MySQL Db?

Feb 18, 2010

I have tried a few packages but cannot find an easy intuitive interface for editing tables in a mySQL database. I just need to simply edit the table field data, import and export multiple rows, and filter the table data so only the rows are returned based on a string that I search for. The tables I edit have several thousand rows and some up to 30,000. I do not know how to write queries and it seems all these packages require that you know how to write sql queries to do what I need to do. On the mac I used Sequel Pro, which is dead easy to use and is mostly point and click to do all the above. Since my mySQL experience is very limited, I really need something simple like this.

I have tried:

MySQL Workbench
Navicat (lite version)
MySQL Query Browser

how to do what I need to do with the above packages.

View 7 Replies View Related

Programming :: Unable To Delete A Table In MySQL?

Oct 17, 2010

A sed mishap prior to a database import left me with a table name with, eh, well, this: Code: mysql> show tables;

| Tables_in_someday |
| day20101016 |
| day20101017); |

I've corrected the sed mishap and imported the database the way it was intended Code: mysql> show tables;

| Tables_in_someday |
| day20101016 |
| day20101017); |
| day20101017 |

But I can't seem to drop the table day20101017); because no matter how I seem to escape it it errors.

View 1 Replies View Related

Server :: Removing Old Table Data From MySQL?

Jul 6, 2009

When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:


View 1 Replies View Related

Server :: Mysql MyISAM Table Doesn't Have .MYD And MYI Files

Jan 26, 2011

We have a MyISAM table without .MYD and .MYI files for storing data and index but we can select data from the table. We can't use mysqlhotcopy for backup the table. Each time,we execute mysqlhotcopy, we have the following error: 'dbs.table: is not base table'. How do we repair the table to re-create .MYD and .MYI files?

View 2 Replies View Related

Server :: Mysql Optimization -- Copying To Tmp Table On Disk?

Nov 16, 2010

we had a CENTOS 5.5 x86_64 machine with 8ered with MySQL 5.0.91-community.Currently we had a very high number of Created_tmp_disk_tables (31k in 4,5 hours!!!).I've read suggestion that we need to increase tmp_table_size, and we've set tmp_table_size to 64M, but this drupal modul's query still cause mysql create tmp table on disk

SELECT DISTINCT node.nid AS nid,
comments.subject AS comments_subject,


View 4 Replies View Related

Software :: Change Date Format In Mysql Table?

Jun 26, 2011

I want to insert a acess log file to mysql table.

my log file look like this;

08/Apr/2011 10:51:19 http://v4.netlogstatic.com/v6.00/385...t.messenger.js
08/Apr/2011 10:51:19 http://download.windowsupdate.com/ms...536945da07.exe
08/Apr/2011 10:51:19 http://www.google.lk/search?
08/Apr/2011 10:51:19 http://clients1.google.lk/generate_204


i want to insert this in to a table which having datetime (as it is in log file) and the site visited.

I created a mysql table using DATE using the date type and the TIME suing time type.but once i loaded this log to table date field shows empty. like following.

| 0000-00-00 | 04:18:29 | http://www.espncricinfo.com/navigati...scorecard.css?

how can I solve this problem.your responses are highly. My table should look like the following

| 08/Apr/2011 | 10:51:19 | http://www.radioeksen.com/song.txt

View 1 Replies View Related

Software :: Conky And Inserting A Row In A MySQL Table With Some Variables

Jul 31, 2010

Making a low-pace instance of Conky on my server, running once a minute and without X-output. and then every minute it inserts a row in a MySQL table with some variables. Once it is in a MySQL database I can make a nice PHP-application showing some graphs and statistics or maybe even send a mail when the motherboard is catching fire or so

View 3 Replies View Related

Software :: Mysql Logging For Specific Table Activity?

Sep 21, 2009

How do you guys to do just that? I know the option for global logging, with parameters --log on service run or log-bin and err-log for inside my.cnf. But what i am looking for is a way to log specifically a table activity, any activity, be it select or update queries.

View 1 Replies View Related

Programming :: MySQL And PHP - Table Column With Multiple Values?

Dec 1, 2008

I am writing a script to mine data from my game server logs which are going to mysql. My first question is syslog-ng is sticking $msg into one colum it self, $msg tends to be a long string here are a few examples:

cn name team frag death flags role host.
0 Maik CLA 2 0 0 normal *.70.233.118.
1 lizardncd RVSF -1 3 0 normal
[*.22.247.40] lizardncd fragged Maik.

And they are not always in the same format, How could I parse this data to do something useful, like creating a user stats page with frag counts and flag counts. Should I create a script that runs in a cronjob that parses this data to a new table maybe once a day. Even then the $msg string value is random and I am thinking in terms of awk.

Second. I would like to keep track of what ip's are using what nicknames. Kinda in the sense of and ip associated to a array of names that have been used on that ip address so I can keep track of users. How would this work logically with a mysql db, could a column allow multiple values, then loadable into an array, which then can add, remove, and store to mysql.

View 1 Replies View Related

Programming :: Using Perl To Update Mysql Table On Certain Event?

Feb 6, 2011

I'd like to use a perl script to update a fields in mysql database when pianobar (command line pandora radio player) starts a new song. Pianobar has the ability to run a script based on events, I'd like to take advantage of and use perl toparse the artist,song,album and update the corresponding fields. Then later retrieve them and display them with php/html. I am by no means proficient with perl. I started to use bash, but it looks like perl will be much more efficient and and less time consuming.

#! /usr/bin/perl -wT
use strict;


View 2 Replies View Related

CentOS 5 :: MySQL Server - User Table Missing

May 27, 2010

I just installed a MySQL server but for unknown reason im not able to set a root password.
CentOS 5.4 - 2.6.18-164.9.1.el5PAE
MySQL Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
# yum install -y mysql mysql-server php-mysql
# service mysqld start
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

View 2 Replies View Related

General :: Copy User Credentials From A MySQL Table Into SSH Users?

Mar 13, 2011

I'm currently running a membership site which is Joomla-based. Basically I need a bash script to constantly check that MySQL users table and copy those credentials into my SSH users list (subsequently giving them SSH access).I've looked at pam_mysql, but that merely is for authentication, it doesnt add them to the SSH users.

View 3 Replies View Related

General :: Mysql Replication Fails After Reading Large Table?

Oct 15, 2010

My MySQL replication slave failed,while reading a large size table from master.Thhe information from error.logError 'Unknown table engine 'InnoDB'' on query. Default database: 'test'. Query: I am sure that table is a Big size table..

View 11 Replies View Related

Server :: Repairing A Corrupted Mysql Table On A Shared Hosting?

Feb 21, 2011

i was trying to do some maintenance on the database and i have the following problem when looking at the database with phpmyadmin on the site

Table Ation Records Type Collation Size Overhead
uc_order_products_pair_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -
uc_order_products_qty_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -
uc_order_products_user_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -


View 2 Replies View Related

Programming :: How To Sort Two MySQL Table On Date Or Time Column

Jul 27, 2011

I have two different table in a database in mysql that has no share key with each other and I want to sort them with each other on their date time column I mean when I sort it row X of table A that is older that row Y of table B comes earlier.

View 3 Replies View Related

Programming :: Perl: Compare CGI Input With Data From A MySQL Table?

Nov 19, 2008

I have this program:

#! /usr/bin/perl
use DBI ;
use strict ;


and I get this error simply running the program from the command line: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./submit.cgi line 24.

is this the right syntax to use, both, for this line:

my (@param) = $cgi->param("firstname","lastname","type") ;

as well as this one:

$sth=$dbh->prepare ("SELECT firstname,lastname,type FROM dts WHERE firstname LIKE $param[0] AND lastname LIKE $param[1] and type LIKE $param[2]" );

or should there be quotes around the $param[0] or something? (also is it $param[0] or $param(0)?)

View 1 Replies View Related

Programming :: Shell Script To Get Count Of Records In A Mysql Table?

Oct 23, 2010

I'm using MYTHTV with AT&T's U-Verse system. AT&T apparently turns off the set-top box if the box doesn't receive any commands after some number of hours. When this happens the box takes so long to turn on that it doesn't process the lirc IR channel change command. I've rewritten my channel changer to add a lockfile, and added a cron entry to kick off an entry to just "ping" the set-top box once an hour. But, OK, I'd like to play the bandwidth saving game and not do this if there isn't anything in the "record" table.

So, how would I write a script that will check the number of rows in the "record" table in the "mythconverg" database and exit if there are zero rows? I'm afraid I don't know how to even start this. Here is my "keepalive.sh" script that does the pinging:

#if there are no rows in the record table, just exit this script
# lock the lockfile - MUST be same one as channel lock
while [ `lockfile "/tmp/mythchanlock.lck"` ]


View 3 Replies View Related

Programming :: Importing MYSQL Table From Text File Wo Column Delimiters?

Jun 13, 2011

I am trying to import a data file from old DOS application into MYSQL table The file is clear text file with fixed-width columns, without column delimiters

Example file :


View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved