1,073 Posted Topics
 | For FreeBSD to rotate the Slow or General Query log the following can be added to /etc/newsyslog.conf: # rotates the mysql logs when they reach 1 meg # and keeps 7 copies /var/db/mysql/file-name.log mysql:mysql 600 7 1000 * J /var/db/mysql/file-name.err mysql:mysql 600 7 1000 * J Alternatively from version 5.1.12 …  |
| | Re: httpd.conf Help? You have to make two separate entries in the httpd.conf file like this: [CODE]NameVirtualHost *:80 <VirtualHost *:80> ServerAdmin webmaster@srvr4.txlinux.com DocumentRoot /var/www/html/txlinux.com ServerName srvr4.txlinux.com ServerAlias www.srvr4.txlinux.com ErrorLog logs/txlinux.com-error_log CustomLog logs/txlinux.com-access_log common </VirtualHost> <VirtualHost *:80> ServerAdmin webmaster@cherryoak.com DocumentRoot /var/www/html/cherryoak.com ServerName cherryoak.com ServerAlias www.cherryoak.com ErrorLog logs/cherryoak.com-error_log CustomLog logs/cherryoak.com-access_log common </VirtualHost> [/CODE] The NameVirtualHost … |
| | Hello, Personally I like defragler. It is free and by the same people who make CCleaner. Gives you many more options and a visual of what is going on. |
| | Re: Joining 5 tables Hello, My best suggestion is to take it one join at a time and watch the results. Can you post your current query here? In the mean time based on what you said in your post I would start the query in the tblTasks table and pull your data from … |
| | Re: help Hit <CTRL><ALT><F5> (or <F6>) you should get a shell login prompt. Linux runs multiple login screens. from there you can login as your user. |
| | Try this site they explain it pretty good. [URL="http://www.roseindia.net/jsp/execute-sql-query.shtml"]http://www.roseindia.net/jsp/execute-sql-query.shtml[/URL] |
| | Hello, You have got to give us a little more than that. Where in "your web"? What site, what is it for and what page is it on. |
| | Hello, Normally in this type of situation I say use "grep" to pull individual lines on a specific file. To get all lines and just the first two fields use "awk". But they only work if the data is on the same line as the information you are looking for. … |
| | Re: cable check Your computer is set to boot from the network (PXE-Boot) or you have a card installed on the computer that is capable of booting from the network. It is simply telling you that there is no network cable connected.  |
| | You need to run your scans from safe mode (or safe mode with networking). Also on another system download UBCD4win (Ultimate Boot CD for Windows) and use it to boot the system and remove the problem files.  |
| | Hello, You also need to add a user to the mysql users table that connects from the remote IP. (i.e. dbuser@192.169.1.2 ) to tell mysql it is ok to accept connections from that host as that user to the specified database. |
| | Hello, I think I ran into what is happening to you. Do you have a separate DSL modem that connects for you using a user name and password. I could connect and use the internet if I was connected directly to the DSL modem but when I added the router … |
 | Check device manager and see if you have a wireless network device listed and if it is working properly. If not re-install the wireless device driver (uninstall first if it is installed but shows a problem.) |
 | If you don't see the security tab at the top you need to go to the folder settings and un-check the bottom option called "Use simple file security" (or somthing along those lines but it is at the bottom. Once you have done that you can use the security tab … |
 | |
| | Hello, Depends on the OS you are running on the laptops. If it is windows (XP vista, 7) then either run the network setup wizard and create a new local network or turn off the local firewall (your router has one built in) and make sure they are in the … |
| | Hello, My suggestion is to give your laptop a fixed IP address in the routers subnet. i.e. if your linksys is at 192.168.1.1 use an address of 192.168.1.50 for your laptop. IP 192.168.1.50 Subnet Mask 255.255.255.0 Gateway 192.168.1.1 DNS Server 192.168.1.1 And see if yo get internet access. Also try … |
| | Hello, Grab the current of Malware Bytes. It's a free download and run a full scan in safe mode. It will tell ouwhat is wrong and fix probably 99% of it. |
| | Hello, Based on what you are trying to do I would suggest that you run a query first to determine which query you need to run using COUNT. Something like: [CODE]declare @test1 Integer select @test1 = count(id) from firsttable where (what ever condition) if @test1 > 1 and @test1 is …  |
| | Re: SATA vs IDE Hello, i believe if you look into it you will find that an IDE drive (PATA) is basically the same hard disk as a SATA. PATA (Parallel ATA) communicates 8 bits at a time to the drive and SATA (Serial ATA) communicates 1 bit at a time. SATA is faster … |
| | It depends on the version of Access but it has a built in tool for repairing databases. Check your access help for options. |
| | Hello, You need to make sure that Apache is running on the server first. If it is configured then putting the IP address in a browser should take you to the default site for the server. If you get the Apache logo page then the service is running and you … |
| | Hello, Yes it is possible. your code will look something like this: [CODE]UPDATE table1, table2 SET table1.field1 = table2.field99, table2.date_posted = now() where table1.id = table2.table1id [/CODE] |
| | By the look of the code you have a missing quote mark to end the action in the line [CODE]<form action="http://localhost/handle_form.php method="post"> [/CODE] I can only see three quote marks not four... |
| | All you need to do is go buy a small (4 or 5 port ) router from your loca; computer store. You then plug the router's WAN port into the port on the DLS modem and your computers into the LAN ports and it handles the connections. It will give … |
| | Hello, Your problem is that the server you are trying to connect to is not set to accept outside connections from the other server in mysql. Check out the following link at the mysql site more information on howto connect. [url]http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html[/url] |
| | Hello, Assuming you have the variables set correctly and system is not disabled you need a space between the -u and $username but none after-p for $password. The grep for the message is not needed since it goes to the terminal screen and is not output to the file. And … |
| | By the look of the data your date field does not have the variable type set as a "date". MySQL normally displays date in the format: DATE 'YYYY-MM-DD' see the following for more info: [url]http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html[/url] |
| | Re: Cabling This site will explain it all... [url]http://www.winnpsb.org/tutorials/rj45/default.htm[/url] |
| | Hello, I think the problem is that is installation disk is trying to create a separate recovery partition and you have allocated the entire disk to the primary partition. Try leaving 15GB of space unallocated when your are installing XP and see if it works. |
| | [QUOTE=NoisySilence;1200194]Hello, Not familiar with PC connected in network with a domain name. Had to hold CTRL-ALT-DEL to enter my credential, worked fine. Brought the PC at my office, tried to connect to internet, but no connection (figured it was caused by the domain/network ID). Successfully created a new network connection … |
| | [QUOTE=rouse;1191062]A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data.. I am unfamiliar; please read that has having no knowledge of how to … |
| | Hello, The problem is you are not telling sort which column to sort off of. By default is uses the first column. The -k flag in sort tells it what field to use for the sort and the = t flag tells it the separator. You could try: [CODE] sort … |
| | [QUOTE=masijade;1197498]Uhm "==", maybe?[/QUOTE] Hello, A couple of things: Try using the following to call your script (called myscript.sh) so you can watch it run: [CODE]/bin/bash -x ./myscript.sh [/CODE] Your error is probably coming from the ";" at the end of the for line which terminates the [B]for[/B] loop with the … |
 | Re: Raw HDD Recovery [QUOTE=cguan_77;1197159]hi guys, does anyone can recommend a freeware or any tools to recover a raw hdd drive. The system was suddenly corrupted, hdd can still be detected and shown on my computer but upon clicking on the icon it's asking me to "Reformat my hdd".[/QUOTE] Hello, If this is a … |
| | [QUOTE=gvkk;1195859]I have a desktop i am trying to get it connected with wireless adapter. iam able to configure wireless connection settings. once it connects it keeps dropping the wireless connection and connects back in few mins , this happens for ever. i have other laptops that are connected to internet … |
| | It has been a while since I used the windows version but if I remember correctly it is the same syntax for both. It is odd but there is a space between -u USERNAME and no space between -pPASSWORD On Linux I put all my sqlcode in one file (mycode.sql) … |
| | Hello, try this where one.csv is your file and it will create a file with the IP address as the name with the whois data, [CODE]for x in `cat one.csv | sed s/\"//g | awk -F, {' print $2 '} `; do whois $x > $x; done[/CODE] |
| | [CODE]cd "c:\Program Files" move folder newfolder [/CODE] |
| | [QUOTE=andydeans;1196393]Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider … |
 | Who did the email come from? Check with a site like [url]http://www.dnsstuff.com/[/url] and use the who is ption to make sure you are still the contact on the domain name and contact your registrar and tell them you did not make the request. |
| | |
| | [QUOTE=ElegantElephant;1196972]Is it possible to use PHP and a mysql query combined to allow a whole database backup file to be downloaded? For example, I'm currently backup up my database by using the export tool in phpmyadmin, but what if I wanted to add a button or link on my site … |
| | Try removing the foreign key, import the data and then re-create the foreign key and you should be fine. Most of the export/imports scripts I have seen import all of the data first then create the keys at the very end. |
| | I am attaching a word document I put together with screen snapshots on how to connect to MySQL on a remote server using putty. I hope it helps those of you how have questions. |
| | Hello, Quick suggestions are: Create a view instead of a query and make sure you have indexes on the fields you are linking the tables with. |
| | Hello, Unless I am mistaken all you need to do is forward port 8080 to port 80 via your router and Apache will see the request coming in on port 80. Great thing about linux is there is a log for everything. Go look at the httpd logs (error probably … |
 | Hello, There are several ways to answer that and it is yes and no. No windows based application will not work under Linux however there are version available for Linux in some cases that work the same. If not there is probably a free version of an application that performs … |
| | Download the free version of Mal-ware Bytes and install and run it in safe mode till you get not more infections showing up. [URL="http://www.malwarebytes.org/"]http://www.malwarebytes.org/[/URL]  |
| | I usually see that when I have not installed the protocol that Windows needs to be able to communicate between systems. IF you go to Open Network Connections, right click the adapter and click "Properties". When the Dialog box opens look in "This connection uses the following items:" to see … |
The End.