473,799 Members | 3,212 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Properly Re-starting replication process

all,

I've just tried to re-start a replication process and the slave's
tables came up marked as crashed. I'm doing a repair on one of them but
there are a lot of databases/tables so I can't check them all (or is
there a table entry somewhere that flags crashed tables?) Here is the
sequence I used:

On Slave (FreeBSD-6.0):
Stop slave using stop slave
show slave status (slave process and IO are not running). Note bin-log
position and heck it against master.info. It agrees.
Stop mysqld using /usr/local/etc/rc.d/mysql-server.sh stop

On Master (Ubuntu-hoary):
show master status.
stop master using /etc/init.d/mysql stop

Installworld and installkernel on slave.
mergemaster magic
Reboot slave

Start Master using /etc/init.d/mysql start. Verify it's running.
Start slave using /usr/local/etc/rc.d/mysql-server.sh start. Verify
it's running.
Start slave using start slave
login to mysql
use <DB of choice>
select count(*) from blah
'error table marked as crashed and failed auto (something-or-other)'
did repair table blah
select count(*) from blah
big number returned and it's correct.

I've poked around (and will continue) but haven't yet found a recipe
for this re-start sequence. Is there one?

thanks

r

Jan 7 '06 #1
0 1293

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2730
by: sumon | last post by:
Hi, I try to install "pear" on win2k with php 4.3.3 . in Ms/dos when I give C:\>pear list INSTALLED PACKAGES: =================== PACKAGE VERSION STATE Archive_Tar 1.1 stable Console_Getopt 1.0 stable
4
1942
by: Stuart Gerchick | last post by:
When will PHP properly support UNICODE
8
3038
by: Jaime Rios | last post by:
Hi, I created a COM AddIn for Word that performs the functions that it needs to, but I needed to add the ability for the toolbar created by the COM AddIn to remember it's last position and whether it was docked or not. I added the following code to my "OnConnection" function but it fails with an error, "Run-time exception thrown : System.IO.IOException - Bad file name or number." With applicationObject.CommandBars("SampleToolbar")
0
243
by: benny | last post by:
Hi, Anyone use cassini to deploy the asp.net web application face the following problem? I have the asp.net web application that consist the login page and Default page where I always face the images are not being loaded on the login page properly while running the single .exe of Cassini. I already try on IIS that all images are loaded properly ....... Or do I made any mistake since I have one page not loading the images properly but...
1
6302
by: Matt | last post by:
Hi everyone, I'm using the command mysqlcheck --all-databases --auto-repair --silent and I see these warnings (listed below) on a daily occurrence. Is mysqlcheck causing these warnings? I can't see how a table can close inappropriately. How can I prevent this. Hoping to here from MySQL users who have came across this. I'm using MySQL 4.1.11 on RHEL.
6
1806
by: Michael Hill | last post by:
I have this large array with dates in it. There is a function that sorts it for me. The only problem is that in order for it to get sorted properly I have to sort it AlphaNumerically first using this first: list_b_array = cf_array.sort(function(a,b){return compareAlpha(a,b);}); then this:
7
2141
by: I am Sam | last post by:
I have a DataGrid that is passing information to a stored procedure properly but the parameters aren't being casted properly. I was woundering if anyone can tell me how I should properly cast the following: (TextBox)UserPrefix=(TextBox)e.Item.Cells.Controls; string strUserPrefix=UserPrefix.Text; I keep getting the following error and I don't know why because I have declared the UserPrefix as a textbox using "protected...
1
3579
by: Darrel | last post by:
APologies for the cross post...posted in the wrong forum the first time. I have an ASPX page on my server that isn't properly running as an ASPX page. At first, the RESX file would load. I delete the files, reuploaded, and now the ASPX file is loading as plain text in the browser (the source). This is the only ASPX file not loading properly, and it works just fine on localhost. What would be the reason for this not properly being...
2
2541
by: Michael D. Reed | last post by:
I am using ClickOnce to distribute a program. It works well except for one detail. When a new version is installed, the program does not initialize properly immediately after the update. The sequence is the user starts the program, is informed a new version is ready, installs it, when it is complete and the main form is displayed, the user needs close the form, and restarts the program to the form to initialize properly. The problem is...
7
2226
by: robin1983 | last post by:
Hi, good morning everyone, i have a file called attendence.php The problem is that some part of code is executing properly and half of the code is not and i dont get any warning or error message. For more information i m giving the whole code below. please give me the solution, the code is executing upto line no 95 (echo $halfday;) and after this line not a single code is executing. i am not able to get solution. So plaease help me in solving...
0
9687
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10252
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10231
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10027
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9073
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6805
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5585
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4141
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3759
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.