Jump to content

BishopVLE

Members
  • Posts

    9
  • Joined

  • Last visited

Everything posted by BishopVLE

  1. Thanks for the feedback, Yeah the apples are macbooks. Will I need some sort of router as well?
  2. Looking at setting up a small training suite, will be set up as a peer to peer network as theres no long term storage or anything needed, as most of the training is web based. The plan is 10 pc's wired and 8 macs wireless but will hardly be used at the same time looking at 10 concurrent users at one time max. And 2 networded printers. So far we have a 100 MB connection comming in. So if we get a 24 port switch connect this to the incoming connection and then connect the ports to the patch cables, this will work for the PC's? If we then connect 2 Apple Airport Extreme Base stations to the floor boxes which are connected to the switch, would this provide connection for the Macs? If the printers are connected into the switch to we could then print over ip? Does this sound right or am i missing something obvious? TIA
  3. i can remove the file like you said but now get Restarting service MySQL Shutting down service MySQL done Updating MySQL privilege database... failed
  4. Just done an automatic update on opensuse and now mysql is not working propery I get this rcmysql status Checking for service MySQL: checkproc: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld unused SUSEMOODLE:~ # rcmysql try-restart checkproc: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld failed SUSEMOODLE:~ # rcmysql restart Restarting service MySQL Shutting down service MySQL done Updating MySQL privilege database... failed Which means moodle does'nt work Error: Database connection failed. It is possible that the database is overloaded or otherwise not running properly. The site administrator should also check that the database details have been correctly specified in config.php Any ideas how to get mysql back up and running
  5. Just wondered if any of you have to do this. We have to go round all the curriculum areas and set them e-learning targets. do any of you have guidelines for this? TIA Matthew
  6. Any tips for rsync. I have 3 scripts that I did and am happy with as they work. Make backup of moodledata #/bin/sh cp -R /srv/www/moodledata /backups/moodledatacopied/ tar -czvf /backups/moodledata/moodledata.tar.gz /backups/moodledatacopied/ mkdir -p /backups/moodledata/moodledata/`/bin/date +%Y/%b` /bin/mv /backups/moodledata/moodledata.tar.gz /backups/moodledata/moodledata/`/bin/date +%Y/%b/moodledata_%d-%b-%Y.tar.gz` rm -rvf /backups/moodledatacopied/ Make backup of moodlesoftwere #/bin/sh mkdir -p /backups/moodlesoftwerecopied/ cp -R /srv/www/htdocs/moodle /backups/moodlesoftwerecopied/moodle/ mkdir -p /backups/moodlesoftwere/ tar -czvf /backups/moodlesoftwere/moodle.tar.gz /backups/moodlesoftwerecopied/moodle/ mkdir -p /backups/moodlesoftwere/moodlesoftwere/`/bin/date +%Y/%b` /bin/mv /backups/moodlesoftwere/moodle.tar.gz /backups/moodlesoftwere/moodlesoftwere/`/bin/date +%Y/%b/moodle_%d-%b-%Y.tar.gz` rm -rvf /backups/moodlesoftwerecopied/ and make backup of moodle database. #/bin/sh /usr/bin/mysqldump -uroot -p****** --opt moodle > /backups/mysql_backups/moodle/moodle.sql /usr/bin/gzip /backups/mysql_backups/moodle/moodle.sql mkdir -p /backups/mysql_backups/moodle/`/bin/date +%Y/%b` /bin/mv /backups/mysql_backups/moodle/moodle.sql.gz /backups/mysql_backups/moodle/`/bin/date +%Y/%b/moodle.sql_%d-%b-%Y.gz` These all work, and create the files in a back up directory. But once the site grows it will be to big to do full back ups daily. The SQL dump will have to be done daily as normal. The moodlesoftwere how much will that change? would that be ok to do weekly? But whats the best way to do the moodledata one. I have heard about using rsync to do incremental backups but have no idea how to do that with my script. TIA
  7. How safe is MysqlDump with the server running? If I use this # Stop MySQLdatabase /etc/init.d/mysql stop echo `date + \%d/%m/%y.%H:%M:%S ` >> $DATABASEBACKUPLOG echo 'Stopping MySQL database.' >> $DATABASEBACKUPLOG #Dump new files for i in $(echo 'SHOW DATABASES;' | $MYSQL -u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST|$GREP -v '^Database$'); do $MYSQLDUMP \ -u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST \ -Q -c -C --add-drop-table --add-locks --quick --lock-tables \ $i > $MYSQLBACKUPDIR/$i.sql; done; #Start MySQLDatabase /etc/init.d/mysql restart It won't work, unless I comment out the start and stop the database. So is it ok to dump the database with it running? Or how do i do it with it stopping and starting
  8. How do you back up your database?
  9. So any of you use any of these partners id be interested in reviews.
×
×
  • Create New...