User Feedback :: COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP

I have tried and have run into lots of problems with sql errors.

It seems phpbb doesn't create and good backup script.

When I tried importing it in, I run into several SQL Insert command errors. I got tired of messing with it.

Don't worry, I won't make the same mistake again...

The forum that is up is the forum that will always be....

phpBB backup from their control panel only backs up the tables that are native to the phpBB distribution package.

When you do customizations to your phpBB that add new tables you need to use alternate methods to get a fully restorable db backup.

There are mods you can use to capture additional tables you add.

There is phpMyAdmin for smaller db's but is mention phpMyAdmin fails after a certain size. My db is just under 50 MB's and I restore frequently with no posts loss. (fyi - I'm not running phpMyAdmin under DSL but am in debian)

Or there is the native mysql command line arguments that will give you a full insert dump.

I didn't customize my phpbb db at all. Never added more tables. I first tried the phpbb admin restore feature and couldn't restore it...got a lot of SQL errors..

Then I tried the phpadmin, it failed to. I probably could have done it if I was so impatient... I was getting mainly insert errors...

I am very good with SQL. I work with Oracle for work at day long, so it wasn't that I don't know SQL. I just got tired of messing with it.

The DB was only 1.4mb compressed...I think the limit with phpadmin is 2mb...so I was underthe limit.

I'm testing XAMPP-1.5.3a and PHP-Nuke on DSL-2.4. phpmyadmin works fine. I can create, export and import database.

I'm using GRUB Frugal with option: opt=hda3.
Folder /tmp needs to be able to Read/Write for XAMPP. Then, I added the following into /opt/bootlocal.sh

Code Sample

sudo chmod go+rw /tmp
sudo /opt/lampp/lampp start

Quote (NewDude @ Mar. 30 2006,22:50)

I am starting to try to learn Mosix to. I have been reading and trying to learn it and I want to get Mosix running on my network as a test. Maybe this summer I can get 2 test boxes together and test Mosix and try to get it going with DSL.

MOSIX

Definately keep us updated on Mosix. Whether one wants to take part in SETI or has a cool distributed app they want to write, I'm sure there are a number of us who are interested.

BTW, it looks like Mosix will require some mods to the kernel. Fortunately, it's the same version.

Next Page...
original here.