Solved

mysql create table won't replicate to slave

Posted on 2009-05-19
7
2,097 Views
Last Modified: 2012-05-07
Warning: I am not a db admin just a simple person with a need for a database so please excuse...

I have successfully set up a master-slave outfit. however when trying to create new tables on the master using a join per code below, the statement does not get replicated to the slave even though It succeeds on the master. Am I missing something obvious? If not I will be happy to provide any supporting info to get to the bottom of this.

Thanks,
Joel

use mydb;
 
create table mydb.table_tmp_1 select * from mydb.table where field.1 = 1;
ALTER TABLE mydb.table_tmp_1 ADD INDEX datetime(datetime);
 
create table mydb.table1_tmp_1 select * from mydb.table1 where field.2 = 1;
ALTER TABLE mydb.table1_tmp_1 ADD INDEX datetime(datetime);
 
create table mydb.table_1
select mydb.table_tmp_1.id,mydb.table_tmp_1.timestamp,mydb.table_tmp_1.QAQC,mydb.table_tmp_1.datetime,mydb.table_tmp_1.cond,mydb.table_tmp_1.do,mydb.table_tmp_1.ph,mydb.table_tmp_1.rw,mydb.table_tmp_1.sw,mydb.table_tmp_1.temp,mydb.table1_tmp_1.orp,mydb.table1_tmp_1.turb,mydb.table1_tmp_1.press
from mydb.table_tmp_1 left join mydb.table1_tmp_1
on mydb.table_tmp_1.datetime = mydb.table1_tmp_1.datetime
group by mydb.table_tmp_1.datetime;
 
drop table mydb.table_tmp_1;
drop table mydb.table1_tmp_1;

Open in new window

0
Comment
Question by:panguluri
  • 4
  • 3
7 Comments
 
LVL 26

Expert Comment

by:ushastry
ID: 24431880
Pls can you post mysql config file? (my.cnf for linux/unix and my.ini incase fo windows)
Also check what is value set for sync_binlog variables

show global variables like 'sync_binlog';
0
 

Author Comment

by:panguluri
ID: 24432207
Here is the requested info.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
 
 
 
 
[mysqld]
#
# * Basic Settings
#
 
#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
 
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 128K
thread_cache_size	= 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover		= BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
log_error		=/var/log/mysql/mysql-error
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
server-id		= 2
log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Federated
#
# The FEDERATED storage engine is disabled since 5.0.67 by default in the .cnf files
# shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so forth).
#
skip-federated
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
 
lower_case_table_names=1
#The size of the buffer that is used for full joins.
join_buffer_size=2M
 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
 
[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
 
[isamchk]
key_buffer		= 16M
 
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
 
 
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
 
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 538
Server version: 5.1.31-1ubuntu2-log (Ubuntu)
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> 
mysql> show global variables like 'sync_binlog';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sync_binlog   | 0     | 
+---------------+-------+
1 row in set (0.00 sec)

Open in new window

0
 
LVL 26

Expert Comment

by:ushastry
ID: 24432289
My bad... I need both Master and slaves my.cnf
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:panguluri
ID: 24432603
Note, the master is running on Windows 2k Server.  Maybe an important omission?
here is master my.ini
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
 
# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
 
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
 
# Disable Federated by default
skip-federated
 
# Replication Master Server (default)
# binary logging is required for replication
log-bin=esf-binary
 
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1
 
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended 
#binlog_format=mixed
 
# Point the following paths to different dedicated disks
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/mysql-5.1.34-win32/"
#Path to the database root
datadir=E:/MySQL/Data/
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname
 
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
 
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[mysqlhotcopy]
interactive-timeout

Open in new window

0
 
LVL 26

Expert Comment

by:ushastry
ID: 24432941
Pls provide both Master and Slaves config file... You have posted 2 config files... which one is Master's and which one is Slaves?... pls post as

===============Master's config file =====================


===============Slaves's config file =====================

and also error logs from both master and slave servers
0
 

Author Comment

by:panguluri
ID: 24435007
The first posted config file is the slave and the second the master.  Per your request see below.  The slave error log is empty.
===============Master's config file =====================
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
 
# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
 
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
 
# Disable Federated by default
skip-federated
 
# Replication Master Server (default)
# binary logging is required for replication
log-bin=esf-binary
 
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1
 
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended 
#binlog_format=mixed
 
# Point the following paths to different dedicated disks
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/mysql-5.1.34-win32/"
#Path to the database root
datadir=E:/MySQL/Data/
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname
 
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
 
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
 
[mysqlhotcopy]
interactive-timeout
 
 
===============Slaves's config file =====================
 
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
 
 
 
 
[mysqld]
#
# * Basic Settings
#
 
#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#
 
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 128K
thread_cache_size	= 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover		= BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log		= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
log_error		=/var/log/mysql/mysql-error
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
server-id		= 2
log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Federated
#
# The FEDERATED storage engine is disabled since 5.0.67 by default in the .cnf files
# shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so forth).
#
skip-federated
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
 
lower_case_table_names=1
#The size of the buffer that is used for full joins.
join_buffer_size=2M
 
[mysqldump]
quick
quote-names
max_allowed_packet	= 16M
 
[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
 
[isamchk]
key_buffer		= 16M
 
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
 
 
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
 
 
=======================Master Error Log===========================
 
090204 12:27:28 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect key file for table 'C:\WINNT\TEMP\#sql_2ec_0.MYI'; try to repair it
090204 12:27:31 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect key file for table 'C:\WINNT\TEMP\#sql_2ec_0.MYI'; try to repair it
090204 12:29:23 [ERROR] Error writing file 'dataserver-slow.log' (errno: 1)
090204 12:32:03 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86096  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86095  user: 'root'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86089  user: 'root'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86077  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86076  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86075  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86074  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86073  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86060  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86059  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86058  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86057  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 86056  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 85801  user: 'camile'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 85679  user: 'ichart'
 
090204 12:32:05 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2406  user: 'camile'
 
090204 12:39:41  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090204 12:39:42  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 1699339505.
InnoDB: Doing recovery: scanned up to log sequence number 2 1699339505
InnoDB: 10 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 26 row operations to undo
InnoDB: Trx id counter is 0 18721024
InnoDB: Last MySQL binlog file position 0 3412817, file name .\esf-binary.000216
InnoDB: Starting in background the rollback of uncommitted transactions
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720497, 1 rows to undo
090204 12:39:43  InnoDB: Started; log sequence number 2 1699339505
090204 12:39:43 [Note] Recovering after a crash using esf-binary
 
InnoDB: Rolling back of trx id 0 18720497 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720496, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720496 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720495, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720495 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720494, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720494 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720468, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720468 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720463, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720463 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720462, 1 rows to undo
 
InnoDB: Rolling back of trx id 0 18720462 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720461, 2 rows to undo
 
InnoDB: Rolling back of trx id 0 18720461 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720460, 9 rows to undo
 
InnoDB: Rolling back of trx id 0 18720460 completed
090204 12:39:43  InnoDB: Rolling back trx with id 0 18720459, 8 rows to undo
 
InnoDB: Rolling back of trx id 0 18720459 completed
090204 12:39:43  InnoDB: Rollback of non-prepared transactions completed
090204 12:39:44 [Note] Starting crash recovery...
090204 12:39:44 [Note] Crash recovery finished.
090204 12:39:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090205 10:33:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090205 10:33:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1656  user: 'camile'
 
090205 10:33:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1  user: 'ichart'
 
090205 10:33:18  InnoDB: Starting shutdown...
090205 10:33:21  InnoDB: Shutdown completed; log sequence number 2 1701858998
090205 10:33:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090205 11:54:41  InnoDB: Started; log sequence number 2 1701858998
090205 11:54:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090217  8:42:35 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090217  8:42:37 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 24760  user: 'ichart'
 
090217  8:42:37  InnoDB: Starting shutdown...
090217  8:42:40  InnoDB: Shutdown completed; log sequence number 2 1735299691
090217  8:42:40 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090217  8:45:32  InnoDB: Started; log sequence number 2 1735299691
090217  8:45:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090318 14:34:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090318 14:34:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 50975  user: 'jcarson'
 
090318 14:34:38  InnoDB: Starting shutdown...
090318 14:34:41  InnoDB: Shutdown completed; log sequence number 2 1826739394
090318 14:34:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090318 14:38:35  InnoDB: Started; log sequence number 2 1826739394
090318 14:38:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090318 15:07:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090318 15:07:13  InnoDB: Starting shutdown...
090318 15:07:15  InnoDB: Shutdown completed; log sequence number 2 1826764200
090318 15:07:15 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090318 15:10:21  InnoDB: Started; log sequence number 2 1826764200
090318 15:10:26 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090325 11:35:38 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090325 11:35:40 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 52392  user: 'camile'
 
090325 11:35:40  InnoDB: Starting shutdown...
090325 11:35:43  InnoDB: Shutdown completed; log sequence number 2 1834949108
090325 11:35:43 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090325 11:38:35  InnoDB: Started; log sequence number 2 1834949108
090325 11:38:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090420  7:35:38 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090420  7:35:38  InnoDB: Starting shutdown...
090420  7:35:42  InnoDB: Shutdown completed; log sequence number 2 1909330530
090420  7:35:42 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090420  7:38:35  InnoDB: Started; log sequence number 2 1909330530
090420  7:38:35 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090421 15:36:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2777  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2766  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2541  user: 'root'
 
090421 15:36:38 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2336  user: 'root'
 
090421 15:36:38  InnoDB: Starting shutdown...
090421 15:36:41  InnoDB: Shutdown completed; log sequence number 2 1911987239
090421 15:36:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
090421 15:40:58  InnoDB: Started; log sequence number 2 1911987239
090421 15:40:58 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090421 15:41:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
 
090421 15:41:59 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2  user: 'root'
 
090421 15:41:59 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1  user: 'root'
 
090421 15:41:59  InnoDB: Starting shutdown...
090421 15:42:02  InnoDB: Shutdown completed; log sequence number 2 1911987249
090421 15:42:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
 
MySQL: Unknown error 1146
090421 15:54:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090421 15:54:52  InnoDB: Started; log sequence number 2 1911987249
090421 15:54:52 [ERROR] Aborting
 
090421 15:54:52  InnoDB: Starting shutdown...
090421 15:54:53  InnoDB: Shutdown completed; log sequence number 2 1911987249
090421 15:54:53 [Warning] Forcing shutdown of 1 plugins
090421 15:54:53 [Note] 
090421 16:08:11  InnoDB: Started; log sequence number 2 1911987249
090421 16:08:11 [Note] MySQL: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 10:08:25 [Note] MySQL: Normal shutdown
 
090422 10:08:27 [Warning] MySQL: Forcing close of thread 1441  user: 'root'
 
090422 10:08:27 [Warning] MySQL: Forcing close of thread 1282  user: 'camile'
 
090422 10:08:27  InnoDB: Starting shutdown...
090422 10:08:29  InnoDB: Shutdown completed; log sequence number 2 1944582166
090422 10:08:29 [Note] MySQL: Shutdown complete
 
090422 11:45:07  InnoDB: Started; log sequence number 2 1944586335
090422 11:45:08 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 11:47:01 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Normal shutdown
 
090422 11:47:01  InnoDB: Starting shutdown...
090422 11:47:03  InnoDB: Shutdown completed; log sequence number 2 1944586335
090422 11:47:03 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Shutdown complete
 
090422 11:48:36  InnoDB: Started; log sequence number 2 1944586335
090422 11:48:36 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: ready for connections.
Version: '5.0.18-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
090422 13:13:40 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Normal shutdown
 
090422 13:13:40  InnoDB: Starting shutdown...
090422 13:13:44  InnoDB: Shutdown completed; log sequence number 2 1944657298
090422 13:13:44 [Note] c:\progra~1\mysql\mysql server 5.0\bin\mysqld.exe: Shutdown complete
 
090422 15:00:46  InnoDB: Started; log sequence number 2 1944661461
090422 15:00:46 [Note] Event Scheduler: Loaded 0 events
090422 15:00:46 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:08:13 [Note] MySQL: Normal shutdown
 
090422 15:08:13 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:08:13  InnoDB: Starting shutdown...
090422 15:08:16  InnoDB: Shutdown completed; log sequence number 2 1944669767
090422 15:08:16 [Warning] Forcing shutdown of 1 plugins
090422 15:08:16 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:08:21 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:08:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:08:21 [Note] Event Scheduler: Loaded 0 events
090422 15:08:21 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:16:40 [Note] MySQL: Normal shutdown
 
090422 15:16:40 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:16:42 [Warning] MySQL: Forcing close of thread 10  user: 'root'
 
090422 15:16:42 [Warning] Forcing shutdown of 1 plugins
090422 15:16:42 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:18:09 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:18:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:18:09 [Note] Event Scheduler: Loaded 0 events
090422 15:18:09 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:24:52 [Note] MySQL: Normal shutdown
 
090422 15:24:52 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:24:52 [Warning] Forcing shutdown of 1 plugins
090422 15:24:52 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:24:56 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:24:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:24:56 [Note] Event Scheduler: Loaded 0 events
090422 15:24:56 [Note] MySQL: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:25:17 [Note] MySQL: Normal shutdown
 
090422 15:25:17 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:25:17 [Warning] Forcing shutdown of 1 plugins
090422 15:25:17 [Note] MySQL: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:27:43 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:27:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:27:43 [Note] Event Scheduler: Loaded 0 events
090422 15:27:43 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:38:24 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090422 15:38:24 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:38:24 [Warning] Forcing shutdown of 1 plugins
090422 15:38:24 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 15:40:35 [ERROR] Plugin 'InnoDB' init function returned error.
090422 15:40:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 15:40:35 [Note] Event Scheduler: Loaded 0 events
090422 15:40:35 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 15:42:00 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE general_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 15:42:00 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE slow_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 15:43:34 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090422 15:43:34 [Note] Event Scheduler: Purging the queue. 0 events
090422 15:43:34 [Warning] Forcing shutdown of 1 plugins
090422 15:43:34 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090422 16:53:29 [ERROR] Plugin 'InnoDB' init function returned error.
090422 16:53:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090422 16:53:29 [Note] Event Scheduler: Loaded 0 events
090422 16:53:29 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
090422 16:54:22 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE general_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090422 16:54:22 [Warning] Statement is not safe to log in statement format. Statement: ALTER TABLE slow_log MODIFY COLUMN server_id INTEGER UNSIGNED NOT NULL
090427  9:33:00 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Normal shutdown
 
090427  9:33:00 [Note] Event Scheduler: Purging the queue. 0 events
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 9255  user: 'root'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 9077  user: 'camile'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 3744  user: 'root'
 
090427  9:33:02 [Warning] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Forcing close of thread 191  user: 'camile'
 
090427  9:33:02 [Warning] Forcing shutdown of 1 plugins
090427  9:33:02 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: Shutdown complete
 
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090427  9:46:17 [ERROR] Plugin 'InnoDB' init function returned error.
090427  9:46:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090427  9:46:17 [Note] Event Scheduler: Loaded 0 events
090427  9:46:17 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
InnoDB: Error: log file .\ib_logfile0 is of different size 0 87031808 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
090505  7:42:25 [ERROR] Plugin 'InnoDB' init function returned error.
090505  7:42:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090505  7:42:26 [Note] Event Scheduler: Loaded 0 events
090505  7:42:26 [Note] C:\PROGRA~1\MySQL\mysql-5.1.34-win32\bin\mysqld: ready for connections.
Version: '5.1.34-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

Open in new window

0
 

Accepted Solution

by:
panguluri earned 0 total points
ID: 24441225
ok, I think I got it now. Rick James of the mysql forum helped to figure out my issue. Once I cleared the slave errors and reexecuted the script everything worked. I'll chalk this one up to ignorance/inexperience.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question