SurrealDB Docs Logo

Enter a search query

->export()

Exports data from a table.

Note

This method is only available on a remote database targeted with the http protocol.

Method Syntax
$db->export($username, $password);

Arguments

ArgumentsTypeDescription
username required

string

The username to authenticate with.

password required

string

The password to authenticate with.

Example

Example
// connect to the remote database. For the export to work, the database must exists with also existing data. $db->connect('http://localhost:8080', [ 'namespace' => 'example', 'database' => 'example', ]); // Export data $response = $db->export('admin', 'password'); // Create a file and write the response to it $fp = fopen('exported_data.json', 'w'); // Write the response to the file fwrite($fp, $response); // Close the file fclose($fp);