a christian web developer’s random writings
ALTER TABLE `attributes` DROP FOREIGN KEY `attributes_ibfk_1`;
MySQL ERROR 1005 (HY000): Can’t create table ‘Table.frm’ (errno: 150). Here’s the solution.
Example:
ALTER TABLE `race` DROP FOREIGN KEY `race_ibfk_1`;
ALTER TABLE `race`
ADD CONSTRAINT `race_ibfk_1` FOREIGN KEY (`specieId`) REFERENCES `specie` (`specieId`) ON DELETE CASCADE;
$ sudo mount -o loop /path/to/feisty-desktop-i386.iso /tmp/ubuntu-livecd
This command will replace all instances of ‘replaceme’ with ‘newstring’ in files ‘*.php’ on /home/mysite/httpdocs.
find /home/mysite/httpdocs -name '*.php' | xargs replace 'replaceme' 'newstring' --
208.67.222.222 and 208.67.220.220 on your /etc/resolv.conf.http://www.opendns.com/support/cache/ then enter the website address. cat /etc/passwd | cut -d":" -f1
Follow the links:
Virtual host examples from Apache website.
http://httpd.apache.org/docs/2.0/vhosts/examples.html
Turns out that it is possible to have multiple VirtualHosts on port 80 (Default http), but because of a limitation of SSL, we can’t have multiple VirtualHosts on port 443 (Default https).
I solved the problem as follows. I created the two VirtualHosts on port 80, one on port 443 and one on port 444.
Shared IP, multiple vhosts and multiple SSL certificates on Apache
The process is only 2 steps and involves modifying your Apache configuration.
1. Create virtual hosts “map file”.
2. Modify existing SSL vhost.Caveat: The SSL certificate used will be common to all SSL vhosts.
Hosting multiple SSL vhosts on a single IP/Port/Certificate with Apache2
The following article discusses the following:
Basics Of Virtual Hosts, Name-Based Virtual Hosts, IP-Based Virtual Hosts, Configuring IP Aliasing, Virtual Hosts with IPs, Multiple Instances of Apache, Example for name based virtual hosts, Example for IP based virtual hosts.
$ gzip -d compressed_file.gz
<html>body {
<head>
<style type="text/css">
font-size: 12px;
font-family: arial;
}
a {
margin-top: 1px;
display:block;
line-height: 25px;
border-left: solid 10px #DDDDDD;
text-decoration: none;
padding-left: 11px;
background-color: #EEEEEE;
}
a:link {}
a:visited {}
a:hover {
padding-left: 12px;
border-left: solid 10px green;
border-bottom: 1px #333333;
background-color: #CCCCCC;
color: blue;
}
a:active {}
</style>
</head>
<body>
<div style="margin: 50px 0 0 10px; width: 220px;">
<div><a href="../saps.php">visitors, click here</a></div>
<div><a href="cms/">admin, proceed to saps</a></div>
</div>
</body>
</html>
These free tools have been designed to validate and check the health of your public DNS servers.
Free Secondary DNS for your domains. If your looking for another DNS to put your domain in, this is for you. Providing additional secondary servers can greatly improve the reliability and accessibility of your domain. Should your primary DNS become unavailable due to network problems, your secondary DNS entries come into play, the more DNS servers you have, the greater the resilience to errors.
Here are the SQL commands:
create database newdb;
grant CREATE,INSERT,DELETE,UPDATE,SELECT on newdb.* to newuser@localhost;
SET PASSWORD FOR 'newuser'@'localhost' = password(’newuserpass’);
– or –
SET PASSWORD FOR 'newuser'@'localhost' = old_password(’newuserpass’);
flush privileges;