OK ... first I did my program at home. So, I created a database called project_db with a few tables in it. Then I want to bring it to work, so I copied folder project_db which was created in ...\mysql server 5.0\data, then I paste in inside the same folder in my office PC.

When I type show tables, all the tables name appeared but when I want to select * username from users, there is an error 'project_db.users' doesn't exist.

Is it suppose to be like that? How do I bring a database from one place to another place without having this error?

Thanks in advance!!

em is not like that we transferring a database from a pc to another pc..what u can do is make a SQL dump file out of it. It's simple, in your database, just klik the tab export, and choose the tables that you want to export, then klik export as file..
on the other pc, create a blank database, then go to SQL tab, then just browse your saved sql file, then klik go,,ahah thats it

__________________
Perlukan Website untuk E-biz?
Belajar membuat web PHP secara percuma di www.mdpai.com

Adeh!! Sesuka ati jer I copy paste. Hehehe ....... no wonder ler doesn't exist.

Anyway, I tak braper paham ler mdpai. Tab yg ndak klik utk export tu kat mana eK?!! File database tu ada kat folder c:/Program Files/MySql/MySql Server 5.0/data ... so, I ndak klik kat mana.

Thanxx

export tab tu ada kat phpmyadmin.
kalau u copy folder database ke pc lain. pastikan fail fail MYD dan FRM tu ada.
lebih baik gunakan export melalui phpmyadmin. copy and paste kadang2 boleh kena file corupt

__________________
Ipoh Chai | Free Blog Directory | Free PHP Game script

go to your phpmyadmin, then choose your desired database, then follow above instructions, (click on the export tab, bla bla)...

__________________
Perlukan Website untuk E-biz?
Belajar membuat web PHP secara percuma di www.mdpai.com

I haven't install phpMyAdmin in my PC yet. So, how can I do it by using Command Prompt Window?

Thanks.

its much easier to manage your database with phpmyadmin, I strongly suggest you install one.
you may need to use mysqldump or mysqlhotcopy to create a backup file of your database
MySQL AB :: MySQL 5.0 Reference Manual :: 8.12 mysqldump — A Database Backup Program

MySQL Open Source Database - mysqlhotcopy, Copying MySQL Databases and Tables

__________________
Ipoh Chai | Free Blog Directory | Free PHP Game script

kat rumah tu marukochan pakai software apa?

__________________
Personal's Blog! - Malaysian Artist!

Wah!! It took me three straight hours just to get my phpMyAdmin running on my PC at home. Next I have to install it at the office. Yeah! Now I can see the export/import tab there .........

At home, to create the database and tables, I just use the command prompt window. To write the script I use Dreamweaver trial version which going to end in another 19 days .... which is about the time to submit my Project Paper. I have wasted 3 months doing nothing and now I'm like crazy trying to finish my Project Paper. When you are studying part time and lack of effort, you are going to end up like me ...... doing things last minute. Ha! Ha!

Guys!! Can you help me out with my script. I've been in front of the PC since 2:30 am and now it is already 5:30. I'm beginning to see stars already and I think I'm going to

Ok, I have a table called 'code' which has code_id, code_string, status. After the code_string is being generated the table will look like this

code_id code_string status
1 v59cgj0 NULL

What I want to do is after the user has submitted the code, I want to change the status to 'YES' so that when another user use the same code, error message 'Verification Code Has Expired' will appear.

However, I'm not able to change the status. Is my query wrong?

Here is my script

...
...
if (!get_magic_quotes_gpc()) {
$_POST['code'] = addslashes($_POST['code']);
}
$check = mysql_query("SELECT * FROM code WHERE code_string = '".$_POST['code']."'")or die(mysql_error());

//Error if code does not exist
$check2 = mysql_num_rows($check);
if ($check2 == 0) {
die('INVALID VERIFICATION CODE. <a href=verification.php>TRY AGAIN</a>');
}
while($info = mysql_fetch_array( $check ))
{
$_POST['code'] = stripslashes($_POST['code']);

//gives error if the password is wrong
if ($info['status'] != "") {
die('VERIFICATION CODE EXPIRED');
}
else
{
$insert = "INSERT INTO code (status) VALUES ('YES') WHERE code_string = '".$_POST['code']."'";
$add_insert = mysql_query($insert);
//then redirect them to the registration page
header("Location: registration.php");
}

......
........

what kind of error did you get?

__________________
Perlukan Website untuk E-biz?
Belajar membuat web PHP secara percuma di www.mdpai.com

OK guys!! I manage to get all my script running. Fuh!! At least 1/3 of the script is running already. Now need to stop for a while to do some literature review to be written in my thesis.

I'll be coming to this forum again somewhere next week should I face any problem with my script (another 2/3).

Thanks everybody for replying my posts!!