to export my mysql what all options do I need turned on???

also there are the ubbt_ files and w3t files, I think I only need the ubbt_ correct?

You are better doing this from the command line.

MySQL Export: mysqldump -uuser -ppass database_name > dump_name.sql
MySQL Import: mysql -h localhost -uuser -ppass database_name < dump_name.sql

that is right .... I remember you saying that before..

I use a mac... not sure what to put that command line...

You need to run something like putty or another ssh terminal software application.

I do not use a mac, so am afraid I cannot comment upon what may work.

You need to ensure though that you have ssh connection to your site.

The w3t_ ones are for the old forum so you won't need those.

As Ian noted, you'll need ssh access to your site to do the command line dump. If you do have ssh access then you can just use the terminal in the mac to ssh to your site.

Thanks Ric - wasn't sure about the Mac.

It's been awhile since I've been on a Mac, but since I spend 90% of my day in some sort of SSH client, when I did have one it was the first thing I looked for

ok I downloaded a program called fugu


I then put in this command

MySQL Export: mysqldump -dbo122662337 -XXXXXXXX db122662337 > dump_name.sql

XXXXXXX is my password
I tried it without the "MySQL Export:" and with it... it rejected it...
suspect there is a - missing?

Really appreciate the help from both of you..

You need -uUSERNAME -pPASSWORD (keep the u and p in there)

As for fugu, never used it -- but I like the name

You don't need the MySQL Export: portion. You only need:

mysqldump -dbo122662337 -XXXXXXXX db122662337 > dump_name.sql