Software :: Update Part Of A URL To Another URL In MySQL?

Feb 15, 2009

I have about 5k of data i need to update.. this in my current database:

[URL]

I want to change it to this:

[URL]

So basically, I want to change only part of the URL, not the entire URL.. is there a way to do this? so only this part of the first url:

[URL]

to

[URL]

View 2 Replies


ADVERTISEMENT

Ubuntu :: Mysql 5.5.6-rc Error During 'make' Part Of Compilation Of Mysql V5.5.6rc?

Sep 26, 2010

getting foll error during 'make' part of compilation of mysql v5.5.6rc

Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....

View 9 Replies View Related

Debian :: Get Mysql To Update From Lenny (mysql-5.0) To Squeeze (5.1)?

Aug 20, 2010

I can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.

View 1 Replies View Related

OpenSUSE :: How To Roll Back Part Of An Update

Sep 25, 2010

opensuse v11.3
linux 2.6.34.7-0.3-desktop x86_64

The most recent update that produced the kernel version above is bit of a disaster for me. The open source radeon driver does not work with VirtualBox (it crashes at startup), and the ATI fglrx driver either builds without acceleration (or the X server loads it that way?) or fails to build.

Is there a way to undo some (or all, if necessary) of the update?

View 9 Replies View Related

OpenSUSE Install :: New Kernel As Part Of Auto Update?

Jan 20, 2010

the normal auto updater ran and installed a new kernel for security vulnerability and it was a .pae version. So after restart I now have 4 options on the boot screen, which includes the normal "SUSE" and a 'SUSE pae" version. defaulted to the new pae version and booted up. I got the video definition not found and had to enter a value manually. The system comes up but not into x system. It gives me a login prompt and startx yields a "terminal not found." Ran SaX2 and startx now works. Unfortunately my KDE desktop is messed up now. There are none of the normal "taskbar" at boot up started processes there. So what should I have done? how do I get my system back to normal and roll out the new kernel and all these changes?

View 6 Replies View Related

OpenSUSE Install :: Makes A Package Part Of Online Update?

Sep 7, 2010

how certain packages such as glib, yast2, etc. are part of "Online update" i.e. new versions show up there, whereas certain packages are not (e.g. NVIDIA drivers). Is it a setting on the repository, the package, or does the new version need to be labelled specifically?

View 3 Replies View Related

Ubuntu Installation :: After Dd From Full 15GB Part To 1.3TB Part, Shows Same Free Space?

Dec 8, 2010

I just used dd to clone a linux partition to a new hard drive, it had 800mb left on the old hard drive, after dd, new hard drive lists 1.29/1.3 terabytes full. Is this what happens by default in dd? How can I fix this?

View 1 Replies View Related

Server :: How To Access Local Part / Domain Part Of Email Address In Postfix's Main.cf?

May 24, 2010

I'm trying to figure out how to access the local part and the domain part of an email address in postfix's main.cf. For example, myname@mydomain.net has myname as the local part and mydomain.net as the domain part.I get the whole email address with %s. I want to speed up the lookups by writing better database queries.I've had no luck finding this in the otherwise well documented postfix.

View 2 Replies View Related

Software :: Server Hosting Different Part Of Web Site Must Appear As Part Of Domain

Jul 13, 2009

we have access to one domain name , 1 internet ip address and may servers hosting different part of site. I want them all to be accessed via same web site . some of the server in our network are embedded devices.they have their specific utility being hosted on that machine. So the severs are bound to be distributed . I just wanted to know how can I access them via single ip, domain name.

View 6 Replies View Related

Hardware :: Is CMOSRAM Is Part On Mother Board Or Part Of RAM?

Jan 14, 2010

In bootseqence of linux, the first step is check the CMOSRAM(size 64bytes) setup for custmor setting. So i am just confused wether CMOSRAM is a part of motherboard or is a part of RAM itself.

View 4 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 Replies View Related

OpenSUSE :: MySQL Workbench Update On 11.3?

Oct 30, 2010

I'm running OpenSuse 11.3 which comes with MySQL Workbench V 5.12.16-8.2. This version hangs on connections and has several other behavior problems that others have reported. For several reasons, I need 5.2+ . As a relatively new regular user of OpenSuse, I've learned that it's much better for me if I work within the package environment (read: I've made mistakes and am willing to learn) so I'm reluctant to try to just load the Suse rpm off the MySQL.org site. So:is there a more recent release of Workbench in a repository I've not found yet? if not, what's the safest way to install this as an rpm that will not impact the rest of the package management system?

View 6 Replies View Related

General :: Update Mysql Database From 5.0 For 5.1?

Sep 5, 2010

i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this

View 2 Replies View Related

Server :: Cannot Start MySQL After Update

Jun 14, 2010

I cant start mysql of my server after the update. my operating system is centos. I get this error.
MySQL Daemon failed to start.
Starting MySQL: [FAILED]

View 4 Replies View Related

CentOS 5 :: Update PHP To 5.3.8 But Stay On MySQL 5.1?

Aug 31, 2011

I wish to update a CentOS 5.6 system to PHP 5.3.8, but keep the MySQL version at 5.1.

I am using these repos (in addition to the stock CentOS repos):

epel
rpmforge
remi

At present, the system has php-5.3.5-1.el5.remi.1 and mysql-5.1.53-1.el5.remi.

When I attempt to 'yum update php' it automatically wants to update mysql to v5.5. If I explicitly exclude mysql either on the yum command line or in the remi repo config file, it produces depsolving errors.

Where may I find a set of PHP 5.3.8 RPMs which are NOT dependency bound to an upgrade of MySQL from v5.1?

View 1 Replies View Related

Ubuntu :: No UPnP Message After MySQL Update?

Jul 26, 2010

I just ran some system updates today. MySQL was among them. after rebooting. I got a message I haven't seen since I was first installing several months ago. I couldn't connect to the database.

At first, I freaked out because I didn't know what to do. I tried checking my passwords, but I still don't understand all the configuration for MySQL. I tried reconfiguring the myth packages, but couldn't get through the setup. It would just bounce me out after a few attempts because of incorrect password sets.

I finally figured out, from the logs, that MySQL hadn't logged anything since it's 'successful shutdown' after the updates. It hadn't even tried to come on. I started it manually and everything seems to be fine, but how do I get it to start at startup again?

View 3 Replies View Related

Software :: Cannot Get Php Script To UPDATE Mysql Database

Apr 11, 2011

I'm having problems with my coding. Here is the problem: I have a database with a list of products. I can list all the products OK At the side of each product I have an EDIT and DELETE button. The delete button works fine and deletes the item. The EDIT button displays a form with all the details from the database. I can then edit this form and click on UPDATE. This is the code that I have to update the database:

$group = $_REQUEST['group'];
$description = $_REQUEST['description'];
$quantity = $_REQUEST['quantity'];
$price = $_REQUEST['price'];
$type = $_REQUEST['type'];
$type2 = $_REQUEST['type2'];
$order = $_REQUEST['order'];
$status = $_REQUEST['status'];
[Code]....

I cannot see anything wrong with this code. But when I click on UPDATE (in the form), I get Error in executing UPDATE exhausts SET group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price = '57.00', type = 'alloy', type2 = 'all', order = '', status = '1' WHERE id = '3' query

error:1064 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 'group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price' at line 1I have used this code many time before in other projects without problems.

View 2 Replies View Related

CentOS 5 :: Yum Broke After Update And Installing MySQL TOP

Nov 28, 2009

After updating and installing Mysql's TOP, yum broke. When trying to clean, update, or install, the following error occurs:

dingle@its:/home/dingle# yum update
There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: No module named cElementTree
Please install a package which provides this module, or verify that the module is installed correctly.
It's possible that the above module doesn't match the current version of Python, which is:
2.4.3 (#1, Sep 3 2009, 15:37:12)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)]
If you cannot solve this problem yourself, please go to the yum faq at: [URL]

I tried to resolve by reinstalling the dependency, didn't work either:
dingle@its:/home/dingle# rpm - [URL]
Retrieving [URL]
Preparing... ########################################### [100%]
package python-elementtree-1.2.6-7.el4.rf.i386 (which is newer than python-elementtree-1.2.6-5.i386) is already installed

How can I rebuild YUM appropriately so it will operate correctly?

View 1 Replies View Related

Ubuntu Servers :: Update Process (and I) Can't Stop Mysql?

Mar 10, 2010

I'm running an update, and get this:

Code:
The following packages will be upgraded:
apache2 apache2-doc apache2-mpm-prefork apache2-utils apache2.2-common libcupsys2 libmysqlclient15-dev linux-libc-dev mysql-server
mysql-server-5.0 php5-imap sudo
12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
5 not fully installed or removed.

[Code]...

View 1 Replies View Related

Ubuntu :: Mysql Stop Working After Today's Update

May 26, 2010

I'am using ubuntu lucid, after today's system updates, mysql stop working at all. Log file at /var/log/mysql/error.log does not say anything about today, and whe I try to start it the terminal hang also in verbose mode.

View 9 Replies View Related

Software :: Update Csv File Into Mysql Db Via Bash Script?

Jan 12, 2010

I have a csv file that has a upc code and a qty (inventory). I need to insert it into my mysql table, but the table has several columns including upc, qty, price, etc. point me in the right direction to getting this done? Hopefully I can have a handy script when I'm done and all I do is run that script. I just want to make sure we don't delete the description, price, etc stuff and only update qty, using the upc code as the identifier so that the right qty get's input into the table.

View 4 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.

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

[code]...

View 2 Replies View Related

Debian Programming :: MySQL PHP Insert / Update Fail - Select Succeeds

Nov 6, 2013

I have mysql installed successfully. I can insert rows into my table using phpMyAdmin. I can successful retrieve those rows in PHP with a select statement. However, I cannot insert or update rows from PHP. I get no error messages and everything appears to be working okay, just no results in mysql table.

View 0 Replies View Related

Fedora :: Mysql / PHP / Apache Installation Configuration Module / Library Update

Dec 20, 2009

how to do Mysql, PHP, Apache installation configuration, module/library update

View 2 Replies View Related

Ubuntu Servers :: Update DHCP Leased File To PowerDNS MySQL DB?

Mar 2, 2010

I setup PowerDNS for my local system following

[URL]

How can I update client info from DHCPd leased file to PDNS MySQL for lookup/reverse my network?

View 1 Replies View Related

Debian Configuration :: Rigger A Script When An Email Is Received To Update MySQL Database?

Feb 10, 2010

how to trigger a script when an email is received to update my mySQL database. I do not want to physically send the message to the script, I just want the script to execute and to under execute under a specific mail account.

I thought of setting up a cron job at first, but decided going down that approach would be a huge waste of resources. What method would you recommend?

View 14 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.

View 1 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.

Code:

View 4 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).

Error I receive is:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 6 Replies View Related







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