Specific Word On Multiple Databases

Dec 1, 2007

I am trying to develop a new way to secure my server. But I couldn't find any way i can search for a specific word on the whole mysql server ( All databases )..

View 2 Replies


ADVERTISEMENT

Cron Job With Multiple Databases

Jun 13, 2007

I have several DBs and need to run a cron job on one of the databases every night.

to run a repair/optimize on the DB as its very active, this is the command I thought I would use:
Code:
REPAIR TABLE `etc` , `etc` ,

Code:
OPTIMIZE TABLE `etc` , `etc` ,

How do I specify which database to run this on in the cron in CPanel?

View 2 Replies View Related

MySQL Backup Multiple Databases

Feb 8, 2008

My site is databases driven and runs on around 15 mySQL databases. Im wanting to download a local copy of these databases daily, however, if i try and back them up via cPanel (on a WHM VPS) they give me blank files. Each databases is around 55mb and growing. I can back them up one by one via phpmyadmin, it just takes around 5 minutes per database. Meaning around 40 minutes per night..

Is there any solution for having a script downloading them automatically so i can download them via ftp? I've tried [url].htm but it gives me blank files.

View 10 Replies View Related

Plesk Multiple Databases For Single User

Sep 17, 2007

how to set multiple databases for a single user in plesk.

It only alows 1 db per user.

View 3 Replies View Related

Load Balancing A Specific CPanel Account Over Multiple Servers

Dec 4, 2008

Load Balancing a specific cPanel account over multiple servers

I have a couple of my clients cPanel accounts that I would like to load balance over two or three servers. Is this possible?

If load balancing is not available, what about auto failover?

View 6 Replies View Related

Apache :: How To Redirect Specific Useragent On Specific URLs

May 20, 2015

I have question: How to redirect specific useragent on specific URLs to specific URLs in .htaccess [Question]

E.g.:

I want to redirect 301 with conditional:

Code:
useragent: Firefox
from my url1: domain[dot]com/old-url1/
from my url2: domain[dot]com/old-url2/

to

Code:
to new url1: in my url1: domain[dot]com/new-url1/
to new url2: in my url1: domain[dot]com/new-url2/

I create this in my .htaccess but not work

Code:
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} googlebot [NC]
RewriteRule ^/?this-is-url/?$ domain[dot]com [L,R,NC]

View 1 Replies View Related

2mhost.com The Bad Word

Dec 10, 2007

since 2 days, all my emails to addresses @yahoo.*, scglobal.com and many others use Yahoo email services are bounced back with error like:

reason: 554 Message not allowed - UP Email not accepted for policy reasons.
Please visit [url]

I visited the page and from this to other until I found this page:

[url]

in conclusion, nothing wrong in mail server, its in message content! .. after spending long hours looking for what I'm saying wrong in my emails ...

I found the bad word .. its 2mhost.com
in the SAME message, if I add word 2mhost.com to it, it will bounce back in a second, if I removed it the message go fine.

this of course includes 2mhost.com that appear in URLs, simply .. I'm now can't spell my domain name in my messages

View 0 Replies View Related

Search For A Word In Files Code

Jun 19, 2007

I am wanting to search for a word in the files code iincluding in files in folders in /home/USERNAME/public_html/

View 3 Replies View Related

Apache :: HTAccess - Remove Same Word From End Of URL?

Mar 18, 2013

I've modified my old website, and now need to remove the phrase "cheap-products"

Some example url's

randomdomain.com/product-1000-cheap-products/
randomdomain.com/product-1001-cheap-products/
randomdomain.com/product-1002-cheap-products/

How do I make it so it will forward (seo wise) to the following

randomdomain.com/product-1000/
randomdomain.com/product-1001/
randomdomain.com/product-1002/

View 4 Replies View Related

Plesk 12.x / Linux :: Word Available Without Permission

Sep 1, 2014

So far my upgrade to 12 has been very smooth but one items that I can't seem to find an answer on is I do not have any applications (including Wordpress) available to users to install. I want this only set and allowed and installed by me (the Admin). If I log in as a user only I can install WP and don't want my customers doing this without talking to me first.

Am I missing a place to shut this down or uncheck to allow this to be installed?

View 1 Replies View Related

How To Copy All Filename With The Word 'index' From Src To Dest

Apr 8, 2008

how to copy all filename with the word 'index' from src to dest?

This include index file within directories as well..

this doesn't seem to work. It only copy index.html in public_html .. and stop there..

Quote:

cp -Rf /backup/userA/public_html/*index* /home/userA/public_html/

View 8 Replies View Related

Plesk 11.x / Linux :: Multiple Email Certificates For Multiple Domains?

Nov 11, 2014

I have two domains as virtual hosts on same IP address.

I am getting certificate error for the second domain when I try to check email (using MS Outlook). I can't permanently "accept" certificate, it complains again and again. Certuficate I created and self signed for imap.domain1.com, but the second email server is imap.domain2.com, so it complains.

How do I set separate email certificates for two domains? Is it possible at all?

View 5 Replies View Related

Virpus = Ticket 11 Days Old, Started Working On Issue 6 Days Ago, No Word For 4 Days

Nov 28, 2008

Virpus = Ticket 11 days old, started working on issue 6 days ago, no word for 4 days!

Thats Virpuss customer service and its plain silly.

View 11 Replies View Related

Apache :: Multiple Error Codes For Multiple Pages

Nov 9, 2012

Depending on where u are at on my site (documents pages, training, main root, etc.) will depend on which type of background, footer, header and the like you'll get. Now I was thinking. Is there a way to have multiple error messages for more then one page depending on where you are at on a site? Right now it's intranet site and a modded snitz forum. What is the code and were does it go and in which apache conf file(s) does it go in?

View 1 Replies View Related

How Can I Convert A PDF File To A WORD Doc. File

Oct 3, 2009

have some E_Books in PDF I want to convert them to word document format

Also need a share hosting for this

View 14 Replies View Related

UNLIMITED Databases

Nov 4, 2009

Do u want to run an online e-commerce store? create a forum? or develop the next facebook or myspace? If you answered yes to any of th questions then there are very important factors you need to consider before choosing a host.

You have to understand that there's a difference between Database and database size. UNLIMITED database means that you have as many databases as you want, but of what use is an unlimited database if the disk size for the database is just 50MB for example. Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions. Afterall you might not need an unlimited database afterall.

View 14 Replies View Related

How Do You Backup Your Databases

Apr 19, 2008

So your host keeps at least a daily backup of your database, but if you don't get to the backup in time, you may find that they have a backup of a crashed database. That means its important to have a procedure for getting regular backups by other means too. How are you doing this?

View 9 Replies View Related

Uploading SQL Databases By FTP

Feb 25, 2008

we have been trying to import sql databases through cpanel.

The old server the client was on did not have any control panel. While the new server the client is migrating to, has cpanel. We try importing sql databases through cpanel, but because the sql databases are so large in size, they corrupt while importing them.

The client's old server he would be able to access all his sql databases through FTP.

While with this new cpanel server, we can't upload sql databases by FTP. We are wanting to use FTP because when using cpanel, the sql databases corrupt.

So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?

View 5 Replies View Related

Setting Up Databases

May 7, 2007

Does anyone know anything about how to set up a mysql database? I installed this script for a gallery for wordpress but it won't create it's own databases. I already set one up myself but Im still getting this error:

Quote:

SELECT * FROM wp_fim_cat ORDER BY date DESC

Is there something Im supposed to add inside each database table? And how do I add it to make it work?

View 1 Replies View Related

Export All MySQL Databases

Sep 24, 2008

I need to export all databases on my server to put it on my new server. Is there a quick and easy way to do that without doing the WHM transfer?

View 4 Replies View Related

Path For MySQL Databases

Oct 25, 2009

Just wanted to ask, which folder are the MySQL databases held in for Cpanel? Running CentOS 5 VPS.

View 7 Replies View Related

SQL 2000 Databases Hacked

Apr 14, 2008

Recently I have noticed at least a couple of SQL 2000 databses hacked in different servers. The hacker inserts a javascript code whose source is [url] file. The code is inserted in all records of some tables especially the tables having html code in the records. We are running SQL 2000 on some unused port and not the default port and also we have firewalls enabled in all the servers. We also have the latest updates and fixes applied in the servers. Can anybody throw some light on this and help me find the cause and solution to prevent this from happening again?

View 14 Replies View Related

UK Media Hosting (mp3/avi) - No Databases Or Php

Jun 4, 2008

I have most of my sites on the very reliable clook.co.uk but I only only get around a Gig of bandwidth per month per site.

I'm thinking of getting an unlimited hosting package so I could upload client's music files, large images, video clips etc.. Nothing is illegal or adult. Then I could host my sites as normal at Clook and then point to all the very large files being hosted at the new place.

I think I'd get about 10Gig of traffic max a month. And as it'll just be an extended online harddrive I've no real need for databases, email, php, cPanel etc...

I've seen some unlimited offers at hostpapa.co.uk for 4.99 a month with a free domain. Is there a catch? What do you recommend?

View 9 Replies View Related

Databases Backup ? (Rsync)

Nov 3, 2008

I am using bqinternet.com to backup (Rsync) some accounts.

I sent them a ticket before 2 days and didn't get any reply.

I used this command to schedule a remote backup for specific accounts:

Code:
echo "30 6 * * * root rsync -avz -e ssh ~account1 ~account2 ~account3 myuser@myuser.bqbackup.comerver" >> /etc/crontab

But, I found this command will backup only files.

How can I backup also databases?

View 11 Replies View Related

Visualizing MySQL Databases

Dec 14, 2008

I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together.

I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.

View 3 Replies View Related

MS Access Databases On Server

Aug 26, 2008

My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?

View 1 Replies View Related

Is There A Way To Search Through MySQL Databases

Mar 9, 2007

I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs

However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value?

For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.

View 10 Replies View Related

Are My MySQL Databases Hosed

Sep 14, 2007

My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys)

I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this:

Code:
[root@rosemary v2]# ls -l /mnt/dying/var/lib/
total 68
...
....
-rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status
drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman
drwxr-xr-x 2 root root 4096 Oct 12 2005 misc
?--------- ? ? ? ? ? mysql
drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs
drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp
...
...
And if I try to cd into the dir, I get this:

Code:
[root@rosemary v2]# cd /mnt/dying/var/lib/mysql
-bash: cd: /mnt/dying/var/lib/mysql: Input/output error
I really *really* need this data!

Am I just totally S.O.L. ?

View 1 Replies View Related

Backup MySQL Databases On PC

Jul 20, 2007

I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC?

I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.

View 2 Replies View Related







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