RE: Why Replication stops ?
I have only recently been looking into replication with MySQL. How does it work? Can I do this? I want our externally hosted web mysql DB to be replicated on our internally hosted non public domain intranet DB. Is it possible? Kind regards, Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 > -Original Message- > From: Jeff Kilbride [mailto:[EMAIL PROTECTED] > Sent: 26. maaliskuuta 2003 9:56 > To: [EMAIL PROTECTED] > Cc: Jeremy Zawodny > Subject: Re: Why Replication stops ? > > > - Original Message - > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > To: "hemanth" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, March 25, 2003 11:45 PM > Subject: Re: Why Replication stops ? > > > > On Wed, Mar 26, 2003 at 01:00:33PM +0530, hemanth wrote: > > > Hi Jeremy, > > > > > > Many Thanks for your support. > > > > You're welcome. That's what this list is all about (usually). > > > > > May I know about ur participation in this IT industry. > > > > Yes, you may. :-) > > LOL. Thanks! I needed a laugh after having to re-sync my > master and slaves... (see earlier post) > > --jeff > > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.8: up 50 days, processed 1,733,356,144 queries (394/sec. > > avg) > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Passing data between the web to an Intranet
Has anyone ever simply tried to pass information direct from the web into a secure Intranet mysql DB rather than to a web DB? I am thinking down one of three lines. 1) I use PHP to send an email with the data in it and update our internal DB manually (the worst case) 2) I use PHP which takes data, sends it as an email, puts it into a form which then automatically updates our internal network (interesting idea but I have no clue if it can be done ;o) 3) I use some sort of synchronisation so every time the web DB is updated our internal one is also updated (ideal). I would welcome any other ideas or solutions. Does mysql have any replication or synchronisation functions? I am told Oracle has but haven't seen this or heard of this with mysql. Cheers, Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is it possible to export data from access to MySQL?
Cheers. Sorted very quickly using MySQL front. Good thing is I can use that to get the SQL and then cut and paste it to any DB I like which is PDG! Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 > -Original Message- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: 26. marraskuuta 2002 16:42 > To: MySQL General Mailing list; [EMAIL PROTECTED] > Subject: Re: Is it possible to export data from access to MySQL? > > > > Download MySQL-Font v2.5 > > This is what I used when I switched from Access to MySQL. > > Once installed just load MySQL-Front and click on > "Im-/Export" on the toolbar. Select ODBC Import. > > Viola! > > > > On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: > > > Is it possible to export data from MS Access into MySQL? > > If so how? > > I have a huge amount of data that will take weeks to input and I've > > convinced my boss to use MySQL rather than any other DB because of > > it's compatibility with PHP. However I (probably hastily) *assumed* > > that there would be a way to export the data. Any ideas? > > > > Steve Jackson > > Web Developer > > Viola Systems Ltd. > > http://www.violasystems.com > > [EMAIL PROTECTED] > > Mobile +358 50 343 5159 > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > --- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --- > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is it possible to export data from access to MySQL?
Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get shipping problem continued!
Sorry to keep on at you guys but this is really getting to me now!
I want to pull a shipping quantity (the very last record in the Db) into
a page and am still having problems. Tried looping through the records
and I can't seem to get it to return anything:
function get_shipping($shippingvar)
{
$conn = db_connect();
$query = mysql_query("SELECT MAX(receipt_id) from receipts");
$myrow = mysql_fetch_row($query);
$shippingvar = $myrow["shipping"];
return $shippingvar;
}
Surely it can't be much more complicated than that?
Help please. Smoked 10 fags already!
Steve Jackson
Web Developer
Viola Systems Ltd.
http://www.violasystems.com
[EMAIL PROTECTED]
Mobile +358 50 343 5159
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie needs help....
I have a problem which I'm not sure the best way to go about. We will be shipping products based on weight and I have two types of product with differing weights. Basically we want to charge one price for shipping less than 10 KG and one for anything over that. I wonder how to go about it. I have the weights for each product and have my products organised into two categories in MySQL DB. So anything in category 1 means less than 30 items is below 10 Kilos and 15 in category 2. How would you code this? I have tried adding a weight category to my products table and calculating total weight (then a simple if statement would do the trick) but it leads to other problems which I couldn't de-bug. Basically adding to my products table means my DB won't update due to a Mysql error (column count didn't match or something) so I can't do it that way or at least as my shop is currently working I'm scared of messing with the code too much! I also need to have a combination of the two products so the customer might buy 1 of category 2 and 35 of cat 1 etc. Ideas to tackle this please? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin
Is it possible to use phpMyAdmin to add new databases (not tables whole databases) to my website? I ask because currently my host has provided me with one database and I don't want to mix database tables when adding new features (such as shopping carts and bulletin boards)? I am new to MySQL and PHP so would like some advice, is the way I describe (databases for each website function) a good way to design or should I have all my functions in one large database? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin is this possible
I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed.
I've never used a MySQL database before to create a dynamic website. I've done it loads of times with Access and ASP but now I need some help on developing firstly the database in a windows environment. Then I'll use PHP to access the database but on a Linux or Unix server? Anyone out there know of any (preferably free) tools that will allow me to develop in that way? Or do I need to take a different route? advice much appreciated. kind regards Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
