How To Update Tables Automatic?
I have a table with all FOREIGN KEYS pointing to tables with PRIMARY KEYS. But when i add data to base table(Primary Key) it should auto update the dereived(Foreign key) table
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Automatic Update On Clients?
I'm developing an application wich saves data on an SQL Server Express database, but I'm planning to upgrade to MySql. Only at the server is the program wich add registries, occasionally the clients could add information. Here is the problem: Is there a way on MySql where the information on the clients is updated automatically? something like if a register is added to tell all the clients immediatly, because is crucial for the clients to have the latest data in real-time.
Automatic Procedure On Update?
Is there a way to have the database also Add Column 1, and Column 2 together and put the value into column 3, when a new record is inserted?
Automatic Update Of Values In Another Db
I am trying to integrate a CMS and a fourm. As a solution, whenever there is a change in the users table of the CMS db I want to have it automatically changed (updated) in the forum db as well. Can anyone recommend a solution? Please note that the two user tables differ in structure, just some columns match, like password and such.
Automatic Update At 12 Pm In Mysql
For my final project,I must do cafeteria systems with mysql backend database. This is my system. Student will have $10 and will deduct for breakfast,lunch and dinner.If they eat breakfast $2,so the money will become $8.At the end of the day,they will have $0. Ok,I know how to do that. But how come I using mysql that at 12 pm,the student money will back to $10.
Update Multiple Tables?
situation: a user wants to change their username on my site and their username is littered accross many tables in the DB. If in every one of those tables i've got a static "user_id" column as well as the "username" column, what is the best way to update all of the different tables with the most efficiency?
Update - Mult Tables
Early experimentail stages with Databases. I have this little faq sys running on my dev server BUT just uiploaded to my host and what yer know it aint working.. two tables question and answers two "Poted vars" $an and $id I am trying to update the answer to a qu.... UPDATE answers,questions SET anstext = '$an' WHERE questions.ans_id = answers.id AND questions.id= '$id' I read that multiple tables was only suppoerted on later vers on Mysql...OR is my syntax just wrong
Update 3 Tables At A Time
i have 3 tables namely--- artist, journalist and songs. i try to update the flags in artist and journalist and try to update few fields from songs by firing foloowing qurries. update songs set sname='lala', sname2='my baby' where artistid=6; update artist set statusartist='new',flag1='updated' where artistid=6; update journalist set statusjourn='new',flag1='updated' where journid=4; when i fire the above querries individually they are excuted without any error. when i try to run these querries through my JSP application only the songs data is updated and the rest 2 tables are not. i tried to write 1 combined query including all 3 tables for this,but still it didnt work. can u please tell me a solution for this.
Best Way To Update Multiple Tables At Once
I need to update a few tables at once. I have a form, were I fill in some information about a concert, which updates thez concert-table. Next to this, I need to update the bands-table, the statistics-table, and some others. What would be the safest, and fastest way to achieve this?
Update Query Between Two Tables
I am having a problem with getting an update query to work. here's what I am using: Update stck Set vendor = 'items.vendor' where prtn = 'items.prtn' I am getting a items table not found error. I thought this is what I needed to do to update many records from one table to another.
UPDATE Linking Other Tables
I am trying to do a simple update function in mySql. NOTE. I am using version 3.0.9.4-beta I have 2 tables: Items and Sales_details I want to update a field called >Sales_value< in Sales_details table using value from Items called >Sell< times (*) >Sales_qty< from Sales_details table. This is the codes I have been trying: UPDATE Sales_details inner join Items on Sales_details.fk_Item_ID = Items.Item_ID SET Sales_details.Sales_value = (Sales_details.Sales_qty * Items.Sell) Error msg:[development_DB] ERROR 1064: You have an error in your SQL syntax near 'inner join Items on Sales_details.fk_Item_ID = Items.Item_ID SET Sales_details.S' at line 1 and UPDATE Sales_details SET Sales_details.Sales_value = (select (Sales_details.Sales_qty * Items.Sell) from Items inner join Sales_details on Items.Item_ID = Sales_details.fk_Item_ID) where Sales_details.fk_Item_ID = (select Item_ID from Items) Error msg:[development_DB] ERROR 1064: You have an error in your SQL syntax near 'select (Sales_details.Sales_qty * Items.Sell) from Items inner join Sales_detai' at line 2
UPDATE With Related Tables?
I have a forum structure stored in a MySQL database and recent changes I made to a web site using it made it stop incrementing the "replycount" for threads (yup, pretty silly :-)) anyways, I am working on a stored procedure (or just an SQL statement) that I can call to recalculate the reply counts. The two tables are structured like so: mysql> describe thread; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | tid | int(11) | NO | PRI | NULL | auto_increment | | title | varchar(50) | YES | | NULL | | | lastpost | datetime | YES | | NULL | | | viewcount | int(11) | YES | | NULL | | | replycount | int(11) | YES | | NULL | | | author | int(11) | YES | | NULL | | +------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.01 sec) mysql> describe post; +----------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+---------+------+-----+---------+----------------+ | tid | int(11) | YES | | NULL | | | pid | int(11) | NO | PRI | NULL | auto_increment | | authorid | int(11) | YES | | NULL | | | body | text | YES | | NULL | | +----------+---------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) Is there a way to do an update query that will link the two tables, then group on the 'tid' field, then use the count result from the 'tid' field to inset into 'replycount'? Also, this is an example showing how the info is related, just in case I dont make it clear enough to understand: SELECT thread.tid, thread.title, count(thread.tid) FROM thread, post WHERE thread.tid=post.tid GROUP BY thread.tid
How Do I Automatically Update Tables?
I need some very basic information and ,being new to mysql, am not sure what keywords to use to search for an answer. Would someone please tell me either where I can find the info I seek or what they keywords would be? I have created three tables and added foreign keys from tables 1 and 2 to table 3. Example: #1 person table person_id pr key #2 location table loc_id pr key #3 event table event_id pr key foreign keys: person_id & loc_id Please note that these table examples have more columns than what is being shown. When updating the event table, how do I get the foreign key colums to choose the correct person_id and loc_id and automatically update? So far, the mysql tutorial book does not address this in their examples so I must assume that the foreign key columns were updated manually. Others have told me that this can be done using forms and subforms. If this is so, how?. And, can it not be done also in mysql using the command line? If forms is part of the answer, I am familiar with them, having used them in my website. I am learning php and have created test forms to update my tables. So far, I can't get the tables to actually update although the php code states that I have connected to both the database and table but that is another issue. My point is that I have some knowledge of forms and php. I just can not find any info telling me how the forms, subforms, php and mysql may work together to automatically update the tables.
Live Update Of Tables
I do have the following problem: A local server running MySql includes the database A, another server in another region (connected to the internet) includes a mirror database of A. What I need is to live update the tables of the mirror database via a secure connection. Both networks have an internet connection.
Using Form To Update 2 Tables
how to change ths script below so it can update the same cells in another table aswell the current table. in other words updates two tables at the same time. <?php if ($submit) { require("db.php"); $con = mysql_connect("$db_host", "$db_user", "$db_pass"); $db = @mysql_select_db("$db_name",$con); $sql = "INSERT INTO support (prod_code,prod_name) VALUES ('$prod_code','$prod_name')"; $result = mysql_query($sql); echo "Thank you! Information entered. <a href=admin.php>Click Here</a> "; } else{ ?> <form method="post" action="<?php echo $PHP_SELF?>"> Product Code:<input type="Text" name="prod_code"><br> Product Name:<input type="Text" name="prod_name"><br> <input type="Submit" name="submit" value="Enter information"> </form> <?php } ?>
UPDATE Multiple Tables Difficulties
I've been creating a stock update system that needs to be integrated with an existing database. To update the stock I need 2 tables updated in the same query (unless there is better way). In one table, items_ordered, holds every single product that has been sold and has a field StockUpdated which holds a 1 or 0 depending on whether they have been stock counted already. This will stop future queries counting stock that has already been counted. i.e. the query will look and update each record that has a 0. So far the query is able to update this table successfully.....
Compare 2 Tables And Update One If A Match.
I have two tables "contact_tbl" and "address_tbl". I have a query that compares the email addresses between the two. If a match is found I need to update a specific field in "contact_tbl" with a value of 'yes'. My query is: SELECT * FROM contact_tbl INNER JOIN address_tbl ON contact_tbl.email = address_tbl.email; This works and I get a nice result set showing records where the email addresses match. I now need to update a field "status" in contact_tbl when there is a match. Have been tinkering with this for a while but not sure of the syntax and placement for the UPDATE code.
PROGRAM TO UPDATE DATA TABLES
I need to be able to DELETE selected record & LOAD DATA from a text file or Foxpro table, from a program that can run continuously. I've tried Foxpro, but FoxPro views are too slow. I have also tried issuing these command from Foxpro with an ODBC connection established, but that does not work at all. The object is to remove all records for a member and replace these records with records from a new file. Each transaction will be up to 50,000 records. I need to execute 2 commands: DELETE FROM parts WHERE parts.member_id="xxx" and LOAD DATA INFILE 'd:/xxx.txt' INTO TABLE parts
Can't Update Records When Using Linked Tables In Access
I have a linked table to MySQL 5.0 through MS Access 2003 that utilizes a timestamp field in order to prevent the #Deleted signature happening everytime I create a new record. However, when I attempt to update a previous record I receive the error message: "Reserved error (-7776)" and am subsequently prevented from updating any records. Please note, there are no errors when creating new records, only when I attempt to update an existing one. However, if I remove the timestamp field, updates occur without error. Has anyone else encountered this issue? How might I rectify it?
Automatic Sort
Is there a way to automatically sort "inserts" according to date in mysql? I have searched high and low for something like this in mysql. I know that it can be done in MS sql but cant find it for mysql.
Automatic Sql Instructions
I'm developing a website and a have to import a txt file in my mysql database. It sounds simple but it has to be done automaticly. I don't know how to do that in Mysql, in Sql Server i could use JOBS, but with mysql i really don't know.
Create Automatic
Does anyone know a script that can create a mysql database autmatically when you run the script?
Automatic Replication
I recently set up replication between my linux server (the master) and a windows 2000 server (the slave).Both are running MySQL 4.0.12. I have noticed that replication isn't automatic. If I go to the slave and do "load data from master" it replicates correctly, but I want it to replicate as changes occur. Is that even possible? Also,is it possible to set both of them up as peers, so either will replicate data to the other?
Automatic Date
I've been trying to add a date field that will automatically add Day/Month/Year after my id field, but I'm getting all kinds of errors. `id` int(10) unsigned NOT NULL auto_increment, `approve` varchar(10) NOT NULL default 'false', `SubmitEmail` varchar(50) NOT NULL default '',
Automatic Updates
I'm not sure if this is possible or not, but is there a way to automatically insert data and delete data in a database at specific times during the day? Is there a script or something out there that would allow me to do this?
Automatic DB Backups
I've been looking at a way to backup my DB automatically (say, every day). All I found was this backup (http://members.lycos.co.uk/wipe_out/automysqlbackup/) but I have to idea how this works, especially these 2 lines - Make the file executable :- chmod u+rwx - Every day AutoMySQLBackup will run (if setup on /etc/cron.daily).
Automatic Deletions
How do I prune my 5.0.11 mysql database (running on linux) automatically? What I am trying to do is have some process that will delete all records older that x days from the database. One complicating factor is that only one of the tables in the (snort) database actually has the timestamp the others just have foreign keys to the table with the timestamp.
Automatic Delete
Is it possible for a row to be deleted automatically based on a date that is inserted. I don't want to have to run an sql statement to select and delte the row, i would like the row to automatically be deleted when it reaches a date that is stored in it? is this possible... if not how do websites that have timelimits/expirey dates work? or do they store all the information and only show the information that has not passed the expirey date?
Automatic Failover
I have set up mysql replication at work, so that if in the middle of the night the master server goes down, i do not have to be called in. It will simply switch to the slave. My question is: 1. Is what i mentioned above accurate? 2. If so, what is the procedure for setting up the master-slave relationship again, after I come into work the next day.
Automatic Repairing
I have a mysql database with some myisam tables. It seems that when the database gets too big or something like that, the server performs an automatic repairing (with BACKUP and FORCE options). The normal process is that when a table is repaired, a TMD file is created and the registers contained in the MYD file are copied into it. When all data are successfully inserted into the TMD file, the MYD is deleted and the TMD is renamed to MYD, so it will be used now.My problem is that, I don't know why, the TMD is filled and the the MYD deleted but then the TMD remains with its name (as a TMD file) and the repairing process fails (I get a 144 error code then, next repairings fail as well). Any idea about what can be happening?
Returning The Automatic ID On Insert ?
Is it possible to return the auto_increment ID on inserting a row ? It would save me alot of hassle so i don't have to do another query to get the ID + i'd have problems getting the ID of a row without the ID to say 'where pic_id = $id'. Then again i could just do 'where pic_created = $time AND user_id = $uid'
Automatic Form Generator
Does anyone know of a free software package that would query the schema of a MySQL table and automatically (or interactively) generate a PHP web form for querying/inserting/updating rows of the table? I've done some googling for this and the closest free thing I found was something called Xdobry that was too confusing and badly translated from German.
Automatic Orphan Delete
I have this little database with some relations between my tables. To make it simple, say I have a table named "Person" and another table named "Car". In my table "Person", I have the name and other information about the person, including its brand of car. There is a relation with the table Car, in which there is information about particular brands of cars. Now, say there was 2 people in my list that had a Chrysler, but they both changed. Now, no one points to the Chrysler record of my Car table, so I would like to remove it. Is there a way to automatically do this? Like the Cascade on Delete option? If not, how can I do it?
Automatic Dataset Refresh
I want to display records from my database in a GUI (windows form). Specifically, I want to display the newest record and I want it to update the display (ideally) every time the database receives a new record. I can easily fill the dataset no problem. I have also tried to use the tableAdapter.FIll() function, but iterating over this doesn't seem efficient and I can't get it to work.
Automatic Type Casting
I noticed that negative values inserted into a unsigned integer field will get set to ZERO. Why? I have to use CASE(number as unsigned) when inserting. Example: drop table testing; create table if not exists testing (i integer, b bigint, m mediumint, u integer unsigned); insert into testing values (-10, -10, -10, -10); insert into testing values (-10, -10, -10, cast(-10 as unsigned)); select * from testing; i b m u -10 -10 -10 0 -10 -10 -10 4294967295 Is there a way to avoid using cast? Why not use automatic type casting? The field is set as unsigned. Isn't that enough info to type cast a negative number rather than set it to zero?
MySQL And Automatic Emailing
Is it possible through a MySQL db [with fields for email addresses (hyperlinked), names and birthdates] to send a birthday message automatically (for the date field to the corresponding name/email address) In other words... is there code to request/schedule field1(email address) be sent a link/image/message at/on field2(date) with field3(name) inserted appropriately to personallize the greeting?
Automatic Cell Deletion
tell me how I can have cells from a table automatically delete themselves after say 15 entries. I'm sure this is a very simple action, but I am a very new basic user of mySQL. Is it possible to set up this action within the datbase itself or do i have to creat a new php file to do this..if so...what should it say.
Automatic Database Backup.
Currently Im using phpMyadmin export feature to create a .sql file that I download as a backup of my database.Is there any way I can automatically get the server to create this backup file for me, and email it to me? I am on linux hosting. There is a button in 'Cpanel' called cron jobs which I think could help but Im not sure how to use them.
MySQL Offsite Automatic Backup
Does anyone know of a company that offers automatic offsite mySQL backup on a weekly basis? I often forget to download my backups from the server and would love to sign up for a service that would just do it automatically - I would feel a whole lot more comfortable! I don't like sending them via email as the database is around 500MB and my email provider doesn't like it...
Automatic Operation When Some Condition Apply
I have a table with a big number of rows, on which I do simple operation (basically I need the sums of some columns). As the table gets bigger and bigger, I would like to know if there is a way such than when it reaches a given number of rows (let's say 100000), it stores the results on a new table and use this results for future query (I mean I want to avoid of summing all the rows each time, but I would prefer to use the results I already have obtained). If I have understood well, this could be done with triggers and procedures, but I have no idea about how.
Maxdb 7.5 / Automatic Database Extension
I know my questions have been asked several times, but I could not find a clear answer in maxdb documentation nor in the mailing lists... Can someone give me a pointer to the answers for these questions please: 1) Is it possible to activate some automatic database extension option ? (I have read in some presentation that is does exist), 2) and what are the prerequisites and procedure to activate this option ?
Master Replication Automatic Failover
I am having one master and three slaves. If my master fails suddenly then one of my slave has to become master automatically on any platform (windows/linux). Can you please suggest the process to do this. Note: Manually i know how to do this task, but i need to be do this automatic.
Automatic Natural Join On All Foreign Keys
Is there any automated way (in MySQL 4.1.3) to get the results of a natural join on all foreign keys in a table? In other words, if I have a table T with foreign keys K1, K2, ..., Kn can I get a derived table that has T joined with all the these foreign tables? I am trying to do it now by parsing the CREATE TABLE statement to extract the foreign keys for a table, then using this to join T with these foreign tables. This works decently for 1 level deep (T and all its foreign keys), but I realized that it must work recursively (ie. I must join all the foreign tables on _their_ foreign keys). Even though I can theoretically do it with subqueries, it quickly gets to be a nightmare. Note: I cannot hard-code any table-specific stuff since this is a generic function that is given a table name as input and generates a SELECT statement as output (or returns the records, if I cannot create a SELECT statement).
Real-time Automatic Conditional Data Manipulation
So it happens that I have to delve into the fields I feel very uncomfortable in ... for now. I'm working off the existing MySQL DB, in which I have to: 1. Analyse in real time (or nearly there) every newly entered row in the "entry" table (data is inputed by a third party) based on the set of criteria and depending on the outcome create new entries either in "bad" or "good" tables 2. Perform the same operation but on the different set of criteria on the new entry in the "good" table and create new record in the "output" table, which is then visible to the third party (but contains very different data from originally entered) My original plan was to dive into writing triggers, but this feature does not seem to be supported in the platform of my choice. Are there any GUI tools (or anything that would not require PhD in quantum physics) that can help me to create conditional real-time updates between tables within one MySQL database triggered by appearing new record?
Backup MySQL Via Port 3306 (which Tool? Automatic Backup?)
i have quite a big database on my website - and i cannot get any backup via system dump or scripts anymore, because my hoster added some memory limits - and scripts/dump can't finish... so the only way left is to backup my database via connection to port 3306 and tools like mysqlfront. mysqlfront is unfortunately quite slow and buggy - so do you know any tools which can backup databases via external connection? - it would be great if there are tools which run automatically? (batch/commandline??) backup with mysql.exe - h -u .... is impossible, too!
Complex Query - UPDATE Within UPDATE?
Edit: Before anyone leaves this thread, don't be put off by the regular expressions! They are not the problem, so please stay and read. OK, this query has got my head spinning. I am basically creating a query that goes through each product in a table to update the stock for that particular item with that particular size (i.e. I am talking about shoes - different models and each model has different sizes (uk kids 12 -> uk 11). With each shoe it does (or is meant to do) the following: 1. The PHP script that runs the query is looping through every size outside of the query 2. So for each of these sizes it checks to see whether the product it is currently on matches the size it is on 3. When it finds the size it is on, it then deducts the correct number of units from the stock table 4. The final WHERE clause makes sure this subquery inside the UPDATE only happens when the StockUpdated field of the Product table equals 0 (in other words, the stock hasn't been counted before) Basically what I need to do, is first to make sure what I currently have got does the above correctly but also I need the query to UPDATE the StockUpdated field to 1 only when it has been updated successfully. How could I do this? Unfortunately I cannot just add an extra update entry to the end of the query as this would update the StockUpdated field regardless of whether it has been properly counted or not. Here is the query I have so far (with a little simple PHP around it doing the loop): PHP $shoesizes = array(1 => 'ukk12','ukk13','uk1','uk2','uk3','uk4','uk5','uk6','uk7','uk8','uk9','uk10','uk11'); $numshoesizes = count($shoesizes); for($i = 1; $i < $numshoesizes; $i++) { $stockupdate = " UPDATE heelys_stock,items_ordered SET heelys_stock.size_".$shoesizes[$i]." = (SELECT CASE WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]12( )?(' -- if UK Kids 12 THEN heelys_stock.size_ukk12 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]13( )?(' -- if UK Kids 13 THEN heelys_stock.size_ukk13 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]1( )?(' -- if UK 1 THEN heelys_stock.size_uk1 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]2( )?(' -- if UK 2 THEN heelys_stock.size_uk2 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]3( )?(' -- if UK 3 THEN heelys_stock.size_uk3 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]4( )?(' -- if UK 4 THEN heelys_stock.size_uk4 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]5( )?(' -- if UK 5 THEN heelys_stock.size_uk5 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]6( )?(' -- if UK 6 THEN heelys_stock.size_uk6 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]7( )?(' -- if UK 7 THEN heelys_stock.size_uk7 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]8( )?(' -- if UK 8 THEN heelys_stock.size_uk8 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]9( )?(' -- if UK 9 THEN heelys_stock.size_uk9 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]10( )?(' -- if UK 10 THEN heelys_stock.size_uk10 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]11( )?(' -- if UK 11 THEN heelys_stock.size_uk11 - (items_ordered.Amount/items_ordered.Price) FROM items_ordered WHERE items_ordered.StockUpdated = 0) WHERE (heelys_stock.id = (SELECT heelys_stock.id FROM heelys_stock,heelys_shoe WHERE SUBSTRING_INDEX(items_ordered.Product,',',1) = heelys_shoe.full_shoe_name)) , items_ordered.StockUpdated = 1" // at the moment this last update of the items_ordered table happens to every record!!! even if the other part of query fails // update stock for size $i mysql_query($stockupdate); } Hope someone can see how I can do this? I've been working on this query for 2 or 3 hours now and I've been making reasonable progress but now I am really stumped.
Update Replication, Force Update
Recently an error in the db on my master caused the slave to fail. I noticed this after a few days when I looked at the status and it said "Slave_SQL_Running: No". After looking further I saw what the error was on the master. What is the best method of re-synching the databases? Is there a command to force a re-replication or synch of the dbs? Would you delete the slave's db and update over? In this case, is there a command to pull the data down from the master?
|
TRACKER
