MySQL hot backup: I need to set one up.
One of my clients has started to get worried about their data in their MySQL database, which they have become very dependent on. The database is currently backed up twice daily, once at noon and once at end of business, and the backups are encrypted and stored offsite. However, they want to have a up-to-the-minute backup in case things go very pear shaped with the server. What's the best way to do this? (Note: MySQL 3.23.x)
posted by SpecialK
on Jan 15, 2005 -
12 answers
I'm developing a form Adobe Acrobat which, when submitting, calls a php script, which performs an INSERT into a MySQL database, then comes back with a "Thank you" web page. The script is called just fine and the INSERT works, but the browser hangs on the Thank You page. [more inside]
[more inside]
posted by jpoulos
on Jan 6, 2005 -
3 answers
I know how to make database-driven web sites using Windows servers, Access, IIS, and ASP.
I want to learn how to do the same using Linux, Apache, MySQL, PHP, and... whatever you use instead of Access.
Where do I start?
posted by Mwongozi
on Dec 10, 2004 -
18 answers
MySQL, Apache, and PHP:
I can pull a phpinfo and it says that both mysql and dbx functions are compiled in and enabled, but when I run mysql_connect or dbx_connect, it can't connect. Apache and PHP work together and I can get into MySQL and do stuff via client. How can I make them talk when everything else I have says that they should already be talking?
[more inside]
posted by SpecialK
on Nov 15, 2004 -
16 answers
I need a package to facilitate collaboration among a group of people spread across the Internet/globe. Ideally it would track staff, projects, to-do lists and contacts. Open source (PHP/mySQL) would be ideal. Any suggestions?
posted by Leonard
on Nov 4, 2004 -
11 answers
myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI]
[more inside]
posted by twine42
on Nov 4, 2004 -
8 answers
PHP / MySQL Q: Is there anywhere I can get a script that will scan the contents of a page when it loads and replace a certain value with a string of text? {more}
[more inside]
posted by dobbs
on Oct 4, 2004 -
9 answers
A Movable Type db question: hypothetically, if I wanted to delete all my entries, categorizations, comments, and trackbacks, while leaving templates and config settings intact, leaving me with a nice, clean
tabula rasa, which MySQL tables should I truncate? (I'm on Movable Type 3.01D.)
posted by brownpau
on Sep 26, 2004 -
2 answers
I build a lot of "community" sites - that is, not web communities, but websites that support specific communities. So I'm hunting around for a good set of decent and free PHP/MySQL scripts to do the sorts of things these communities often demand. Now up? A
public events calendar and
classified ads. AskMeFi has
helped before, so hat in hand, I come back to the well hoping for more. [More Inside]
[more inside]
posted by pzarquon
on Aug 6, 2004 -
2 answers
What I have: two older PCs.
What I want to do: run some combination of Bugzilla, Subversion, MySQL,
Trac and a few other apps that I'm testing from time to time.
What's the best way to set this all up in terms of what goes on which box? Also, any general advice or warnings on conflicts or problems I may come across would be greatly appreciated.
[more inside]
posted by yerfatma
on Jul 27, 2004 -
5 answers
GeekLearningFilter: I need to learn how to do some fun stuff with php and MySQL or PostgreSQL. Of course I shall expand on this within...
[more inside]
posted by Dreama
on Jul 19, 2004 -
5 answers
What's your favorite WAMP installer? (and, of course ,why?)
posted by signal
on Jul 19, 2004 -
4 answers
I am a freelance journalist, and a document freak. But also I am very chaotic. I would like to use some sort of database to keep track of the articles, documents, web snippets, references, quotes, URLs, bibliography that I use in my work. But I have many questions and doubts [more].
Should I use a database that it is linked to the external documents (which I keep nonetheless), or should I go for a database that has all of these documents embedded? I work in a Windows / OSX environment (desktop PC and a G4 Powerbook), so this keeps me from going all the way to Access (which I hate) or Filemaker (which I don’t know very well). I’ve been thinking of keeping a MySQL database server, maybe powered with a modification of something like
Everything, and accessing the data via web browser, but I fear that the thing wouldn’t escalate well. (Keep in mind that I am not a programmer, I can install Movable Type or GeekLog in my webserver, and tinker a little with php files changing little things here and there, although I have friends that can help me)
I don’t know if there are built-in solutions for what I need, or if you can point me to a database template (for Access or FileMaker) already built for journalist research. The fact is that I have tons of information and documents (some of them already stuffed in CD and DVD backups), but I have a hard time keeping track of everything, and very often it is very difficult for me to retrieve information that I know I have saved but I can’t tell where it is.
posted by samelborp
on May 11, 2004 -
9 answers
I'm looking at database packages and wondering if anyone has had first-hand experience with
direct interfaces for PostgreSQL, SQLite, BerkeleyDB or MySQL, either of the command-line variety or via a web-based GUI? I'm very familiar with phpMyAdmin but that's where my experience stops. How might the above compare with phpMyAdmin?
Mind you, I already understand the features/benefits/drawbacks of the databases themselves. It's the interfaces (especially web-based) that I'm interested in.
posted by fooljay
on Apr 13, 2004 -
12 answers
I've been fascinated for a while with stiff like tradesports.com and the ill-fated DARPA terrorism futures market, and got to thinking about building a fake, toy futures market. There are systems out there that simulate markets, but they're either simple portfolio charters or they have randomly wobbling shares. I'm much more interested in valuations created by groups of users gaming on the outcome of real events.
Ideally, as I'm very lazy, someone will have written one of these already, but I've googled away and had no joy. It could be me not knowing the lingo used to describe these things.
Failing this can anybody recommend a framework to work within? I'm thinking of something (probably the usual php/mysql) with e-mail/users/password recovery etc. built in for me to start from. Maybe the toy market would be best developed as a plug in to something?
[more inside]
posted by Flat Feet Pete
on Mar 28, 2004 -
5 answers
While there's been a previous "What CMS do you dig?" question, mine's narrower. What CMS would you recommend for a system using W2K Advanced Server and MSSQL? (more inside)
[more inside]
posted by RakDaddy
on Mar 26, 2004 -
7 answers
I have been looking at changing my web development focus from Windows/ASP/.NET to LAMP(Linux, Apache, MySQL, PHP/Python/Perl) because my gut is telling me that this is where things are going. Oh, Java should be in there as well.
What's the skinny on LAMP in the real world (Netcraft
surveys aside)? Is it difficult to change to LAMP/Java? Is the open source thing really sticking?
posted by grefo
on Jan 9, 2004 -
14 answers
Three'fer:
(1) Is there a significant difference between running Linux on Opterons vs. Xeons? Is one clearly better? For MySQL? For Apache/PHP?
(2) Ever hosted with
Cogentco? Is there anyone else with prices like that? (100Mbps at $1000/month)
(3) What's your favorite server vendor for typical 2-way 1U systems? (Looking at Dell, IBM,
Penguin; where does Google buy them again?)
posted by sylloge
on Dec 21, 2003 -
3 answers
I'm interested in filling out my workday learning perl, php and mysql at my own speed. I have no programming background. Anybody have any good experiences with any online courses, or any other advice? Money is not an object, what is important is good structure (logical progression of concepts) and the ability to get personalized help when needed.
posted by luser
on Dec 17, 2003 -
25 answers
I'm new to Mac OS X's command line and a little nervous about using it to install Mysql. After doing some research on the net I found what might be an alternative: installing Apache2, PHP4 and Mysql from
Server Logistics . The post claims that by also installing one of the Barebones text editors and Tinkertool I could avoid having to use the command line altogether. It was also suggested that the Server Logistics Complete Packages are more powerful versions of Apache and Php than apple ships (I'm on Panther). Has anyone done an install this way? Any other suggestions? Should I just get over it and use the damn command line?
posted by btwillig
on Dec 16, 2003 -
13 answers
