Welcome, Guest. Please Login or Register.
November 05, 2024, 06:55:50 AM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  English Help  |  help with mysql « previous next »
Pages: [1] Reply Ignore Print
Author Topic: help with mysql  (Read 336 times)
Putin
Noobie
*
Posts: 21
help with mysql
« on: April 17, 2003, 10:46:41 PM »		 Reply with quote
I'm converting a YaBB sp1 board. But I'm getting continuosly time out errors. So I've decided to convert all on my local pc and then re-upload all the data to my ISP MySQL server. But I can't find an export/import function in mysql. Anybody can help please!
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:help with mysql
« Reply #1 on: April 17, 2003, 11:28:32 PM »		 Reply with quote
mysqldump

-[Unknown]
Logged
Putin
Noobie
*
Posts: 21
Re:help with mysql
« Reply #2 on: April 18, 2003, 08:34:14 AM »		 Reply with quote
Thanks, I cannot understand how I've missed that ;D :-[
Logged
Putin
Noobie
*
Posts: 21
Re:help with mysql
« Reply #3 on: April 18, 2003, 10:31:30 AM »		 Reply with quote
I've checked the reference "4.8.5 mysqldump, Dumping Table Structure and Data". But I'm always getting a 2 bytes file ??? :P :(.

Any suggestion? Can someone write all the syntax please?My DB called "Yabb".

Thanks a lot :D :)
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:help with mysql
« Reply #4 on: April 18, 2003, 08:43:16 PM »		 Reply with quote
mysqldump --opt --databases Yabb | gzip > dump.sql.gz

-[Unknown]
Logged
Putin
Noobie
*
Posts: 21
Re:help with mysql
« Reply #5 on: April 18, 2003, 09:41:38 PM »		 Reply with quote
I must get a coffee :( cause I'm not having success. btw I'm using MySQL 3.23.49...
Logged
Putin
Noobie
*
Posts: 21
Re:help with mysql
« Reply #6 on: April 18, 2003, 09:46:43 PM »		 Reply with quote
 ;D works (I've used the dump in phpmyadmin)

Thanks for the support Unknown! :)
Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  help with mysql « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.058 seconds with 20 queries.