The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
]Hello all
![]() Well... First want to say many thanx to FireFly for all help he have provided and for all his answers ![]() I got a lil problem here. I must export table "templates" from MySQL database on the server where I have not installed myadmin yet and I don't have telnet access to it. So I must use PHP files to connect to the database and dump only one table from there (I'll download it after from FTP). After that I must import it in another database. Just override old table. I don't know if I need to drop it first or I can just override it. I can use telnet/ftp/myadmin there with that MySQL database. So I will be very appreciated if u could paste the string I have to run to get that dumped table imported. As u see I need to export a table with help of PHP file and then import that dumped table with help of telnet/myadmin/PHP file. Please help if u can. Thanx very much ![]() |
#2
|
||||
|
||||
![]()
]
Code:
<? mysql_connect("host","login","pass"); $query = "DUMP TABLE template FROM DATABASE databasenamehere"; $result = mysql_query($query); ?> |
#3
|
||||
|
||||
![]()
wroooooooooooom
|
#4
|
||||
|
||||
![]()
]really no one?
![]() |
#5
|
||||
|
||||
![]()
]can something like this do the job:
Code:
<? system ("mysqldump -u from_username_from -pfrom_password -h from_host from_db from_table | mysql -u to_user -pto_pass -h to_host to_db_name"); ?> |
#6
|
|||
|
|||
![]()
Hi there Woolf,
If it is a one time thing then I'd use phpMyAdmin to dump the table/db and get an sql script which you can run on your second server. If not, may be some one else can offer an opinion ![]() |
#7
|
||||
|
||||
![]()
]well.. I have dumped table allready from one server... now I just need to be sure that commands I gave before are right ones
![]() |
#8
|
||||
|
||||
![]()
thanx for help support... sorted it out myself...
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|