Forum Replies Created
-
AuthorPosts
-
pcdinh
Memberpeterlaursen wrote on Oct 31 2005, 04:00 AM:A question: Can you open that database from SQLyog? and can you export (as a .sql-file for instance) or read the data from ODBC/JDBC .. etc. ???I can open that database. After it crashed, I opened SQLyog again, connections to that database worked fine. All the select and delete statements worked fine. But I decided to delete all the tables in the database and use the query tab to create fresh tables. But the crash came again and again.
However, my hard disk has died. So I can not test it again until I buy a new one. But i will try to test it again on the PC in my company. Sorry for any convenience that may cause.
Dinh
MemberRitesh wrote on Oct 30 2005, 02:23 PM:BTW, are you using any kind of firewall, multiple monitor management software etc.?We had an issue earlier with Multimon found at Relatime Soft
[post=”7740″]<{POST_SNAPBACK}>[/post]I have Yahoo IM with Voice, Apache 5.0.55, PHP 5.1RC3, MySQL 5.0.15, JDK 1.5.0_05, Eclipse 3.1.1 on my computer. No firewall or no virus protection software and monitor software.
All my above query is edited with Query tab on Sqlyog 4.2 Rc2 and I have it excuted without any error. After the tables were created, I tried using the wizard “Copy database…” by right-clicking on that database, clicking on the item “Copy database…” and Windows said it crashed and requested me to send a report.
I just formated and fdisked my hard disk yesterday. My hard disk has expanded some bad sectors. Do you think that it it the cause that leads to Sqlyog crashs. If it is the case, please ignore my bug report. 😆
Thank for your consideration.
Dinh
MemberRitesh wrote on Oct 30 2005, 05:53 AM:As Peter described, we will need more details about your setup. Are you connecting to a remote server?Can you mail me a screenshot of your connection window?
BTW, what does show tables from `yourdb` return?
[post=”7732″]<{POST_SNAPBACK}>[/post]I just installed MySQL 5.0.15 Final on my Windows XP box yesterday and create a database schema to play with InnoDB. Here is my complete SQL script:
Code:/* Database schema for http://www.goldenkey.edu.vn
Create 2 table book_orders and customers
This two table act as the initial tables for the shopping cart
application in http://www.goldenkey.edu.vn
*/
create table courses (id int not null auto_increment,
course_name varchar(40) not null,
startdate date not null,
enddate date not null,
primary key (id)) type=InnoDB default charset=utf8;create table customers (id int not null auto_increment,
name varchar(40) not null,
address varchar(40) not null,
primary key (id))type=InnoDB default charset=utf8;create table enrolments (
id int not null auto_increment,
class_type varchar(50),
valid_from date not null,
valid_until date not null,
customer_id int not null,
foreign key (customer_id) references customers(id),
primary key (id)) type=InnoDB default charset=utf8;create table course_customer (course_id int not null,
foreign key (course_id) references courses(id),
customer_id int not null,
foreign key (customer_id) references customers(id)
) type=InnoDB default charset=utf8;create table book_orders (id int not null auto_increment,
items varchar(30) not null,
saledate date not null,
customer_id int not null,
foreign key (customer_id) references customers(id),
primary key (id)) type=InnoDB default charset=utf8;/* Add the values for customers table */
insert into customers (id , name , address)
values (null, 'Minh Hoang', 'Ha Noi');insert into customers (id , name , address)
values (null, 'Ngoc Ha' , 'Ha Noi');insert into customers (id , name , address)
values (null, 'Minh Lam' , 'Ha Noi');insert into customers (id , name , address)
values (null, 'Truong Anh', 'Ha Noi');insert into customers (id , name , address)
values (null, 'Khanh An', 'Hai Phong');insert into customers (id , name , address)
values (null, 'Khanh Huyen', 'Thai Binh');insert into customers (id , name , address)
values (null, 'Mai Trang', 'Sai Gon');
select * from customers/* Add the values for courses table */
insert into courses (id, course_name , startdate , enddate)
values (null, 'English for IT', '2005-10-18', '2005-12-29')insert into courses (id, course_name , startdate , enddate)
values (null, 'English for IT', '2005-08-18', '2005-10-29')insert into courses (id, course_name, startdate , enddate)
values (null, 'Let's go', '2005-10-18', '2005-12-29')insert into courses (id, course_name, startdate , enddate)
values (null, 'Let's go', '2005-11-18', '2005-12-25')insert into courses (id, course_name , startdate , enddate)
values (null, 'International Business', '2005-11-18', '2005-12-25')select * from courses
/* Add the values for book_orders table */
insert into book_orders (id , items , saledate , customer_id)
values (null,'Let's go','2005-10-12', 3 );
insert into book_orders (id , items , saledate , customer_id)
values (null,'Let's go','2005-10-12', 3 );
insert into book_orders (id , items , saledate , customer_id)
values (null,'Let's go 2','2005-10-14', 4 );
insert into book_orders (id , items , saledate , customer_id)
values (null,'Talk business','2005-10-16', 1 );
insert into book_orders (id , items , saledate , customer_id)
values (null,'International Express','2005-10-16', 4 );
insert into book_orders (id , items , saledate , customer_id)
values (null,'International Business','2005-10-16', 5 );select * from book_orders
/* Add the values for course_customer table */
insert into course_customer (course_id, customer_id)
values (1 , 2 )
insert into course_customer (course_id, customer_id)
values (2 , 2 )
insert into course_customer (course_id, customer_id)
values (3 , 1 )
insert into course_customer (course_id, customer_id)
values (4 , 3 )select * from course_customer;
I used Sqlyog 4.2 RC2 to execute the query. I used port 3307 for MySQL Server on my local host because I would like to use port 3306 for MySQL 4.0 which was not installed yet.
Other tools installed with MySQL 5.0.15: MySQL Query and MySQL Administrator (lastest version)
Best regards,
pcdinh
Member -
AuthorPosts
